Tag: oracle

dbForge Edge: Your Best Universal Tool for Multidatabase Challenges

MySQL, Oracle, PostgreSQL, SQL Server, Tools & technologies

Handling several database management systems simultaneously is inevitable in working on multiple...
Read More

Learning Advanced Analytics Features with Oracle Analytics: Outliers and Clusters

Business intelligence, Oracle BI

This is the second part of the material dedicated to Oracle Analytics. In Part 1, we started our journey and learned to create Reference...
Read More

Oracle Predictive Analytics: How to Predict of Employee Attrition

Business intelligence, Oracle BI

From the Customer Segmentation tutorial, you already know that Oracle Analytics provides several Machine Learning (ML) algorithms to solve...
Read More

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

Business intelligence, Power BI

Oracle Autonomous Data Warehouse (ADW) is a fully managed and high-performance solution, turned and...
Read More

Provisioning an Oracle Autonomous Database

Cloud, Database development

Let’s assume that you are developing a data warehouse project, and your team needs the appropriate environment immediately and under the...
Read More

Create and Configure Oracle Linked Server in SQL Server

Database development

This article explains the step-by-step process of creating and configuring a linked server between Oracle 19c and SQL Server 2019....
Read More

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

Database administration, Database Optimization & Structure

Introduction This tutorial includes information about SQL (DDL, DML) that I have gathered during my...
Read More

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

Business intelligence, Database administration, SSIS, Work with data

In this article, I have explained how we can divide and export data of SQL Server database table into Oracle and MySQL databases. That...
Read More

Exporting Oracle Table to Excel Worksheet

Database administration, Database development, Tables, Work with data

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...
Read More

Configuring Heterogeneous Database Replication – SQL Server to Oracle

Database administration, Database Optimization & Structure

Introduction SQL Server Replication is an SQL Server feature that allows us to transfer data from...
Read More
Close