oracle Archives - {coding}Sight

dbForge Edge: Your Best Universal Tool for Multidatabase Challenges

{coding}Sight — Tue, 06 Jun 2023 11:34:26 +0000

Handling several database management systems simultaneously is inevitable in working on multiple projects. At the same time, each system requires a proper set of relevant tools to perform database tasks. These tools should be powerful and flexible enough to adapt to the project’s evolving needs. One moment, your goal is to design a new database …

The post dbForge Edge: Your Best Universal Tool for Multidatabase Challenges appeared first on {coding}Sight.

Learning Advanced Analytics Features with Oracle Analytics: Outliers and Clusters

Dung Dinh — Thu, 25 Aug 2022 11:02:00 +0000

This is the second part of the material dedicated to Oracle Analytics. In Part 1, we started our journey and learned to create Reference Line, Forecast Line with Sales data. It let us get some essential remarks about the products with outstanding performance or relations between Sales and Profit. In this part, we are going …

The post Learning Advanced Analytics Features with Oracle Analytics: Outliers and Clusters appeared first on {coding}Sight.

Oracle Predictive Analytics: How to Predict of Employee Attrition

Dung Dinh — Fri, 29 Jul 2022 09:38:00 +0000

From the Customer Segmentation tutorial, you already know that Oracle Analytics provides several Machine Learning (ML) algorithms to solve the Supervised Learning and Unsupervised Learning problems with low-code required. Prediction of Employee Attrition is one of such Supervised Learning problems. It is a popular use case that most organizations need to resolve to minimize the …

The post Oracle Predictive Analytics: How to Predict of Employee Attrition appeared first on {coding}Sight.

How to Connect an Oracle ADW with Power BI and Create Sales Dashboard

Dung Dinh — Fri, 07 May 2021 09:52:18 +0000

Oracle Autonomous Data Warehouse (ADW) is a fully managed and high-performance solution, turned and optimized for Data Warehouse workload. It means you don’t need to take more effort and resources (DBA role) to manage the database and optimize the workload. Power BI Desktop is a business analytics service by Microsoft. It offers interactive visualizations and …

The post How to Connect an Oracle ADW with Power BI and Create Sales Dashboard appeared first on {coding}Sight.

Provisioning an Oracle Autonomous Database

Dung Dinh — Fri, 23 Apr 2021 11:58:17 +0000

Let’s assume that you are developing a data warehouse project, and your team needs the appropriate environment immediately and under the minimum budget. Business users have to explore their data as soon as possible. This will be our goal for the current tutorial: to create a data warehouse for importing and exploring the data quickly …

The post Provisioning an Oracle Autonomous Database appeared first on {coding}Sight.

Create and Configure Oracle Linked Server in SQL Server

Nisarg Upadhyay — Wed, 24 Mar 2021 10:43:25 +0000

This article explains the step-by-step process of creating and configuring a linked server between Oracle 19c and SQL Server 2019. Pre-requisites to create a linked server For demonstration, I have installed SQL Server 2019 on my workstation. Along with it, I installed Oracle 19c and created an instance named EMPLOYEE. In my further articles, I …

The post Create and Configure Oracle Linked Server in SQL Server appeared first on {coding}Sight.

Tutorial on SQL (DDL, DML) on the example of MS SQL Server dialect

Sergey Menshov — Sun, 12 May 2019 23:30:30 +0000

Introduction This tutorial includes information about SQL (DDL, DML) that I have gathered during my professional life. This is the minimum you need to know while working with databases. If there is a need to use complex SQL constructions, then usually I surf the MSDN library, which can be easily found on the internet. To …

The post Tutorial on SQL (DDL, DML) on the example of MS SQL Server dialect appeared first on {coding}Sight.

Conditional Split Transformation: Export Data from SQL Server into Oracle and MySQL Databases

Nisarg Upadhyay — Fri, 17 Aug 2018 13:23:34 +0000

In this article, I have explained how we can divide and export data of SQL Server database table into Oracle and MySQL databases. That process is based on the condition defined in SSIS as “conditional split transformation”. Conditional split transformation is like case statement of any programming language. Using conditional, we can redirect the output …

The post Conditional Split Transformation: Export Data from SQL Server into Oracle and MySQL Databases appeared first on {coding}Sight.

Exporting Oracle Table to Excel Worksheet

Nisarg Upadhyay — Fri, 20 Jul 2018 07:39:21 +0000

In this article, I will explain how we can divide and export data of an Oracle database table into multiple worksheets of an Excel file with help of the SQL Server integration service package. Often, DBAs asked to generate Ad-Hoc reports from a database. Recently I have been asked to generate a report from the …

The post Exporting Oracle Table to Excel Worksheet appeared first on {coding}Sight.

Configuring Heterogeneous Database Replication – SQL Server to Oracle

Kenneth Igiri — Fri, 15 Jun 2018 13:49:14 +0000

Introduction SQL Server Replication is an SQL Server feature that allows us to transfer data from one instance to another for such purposes as consolidating data into a reporting environment or migrations. I personally would not consider SQL Server Replication as a high availability technology even though some people consider it to be. SQL Server …

The post Configuring Heterogeneous Database Replication – SQL Server to Oracle appeared first on {coding}Sight.