oracle

Data virtualization in SQL Server 2019

Applies to: SQL Server 2019 on Windows or Linux, SQL Server 2019 big data cluster

SQL Server 2019 introduces new ODBC connectors to data sources like SQL Server, Oracle, MongoDB and Teradata. These connectors can be used from stand-alone SQL Server 2019 on Windows or Linux or SQL Server 2019 big data cluster.

Query data in Oracle from SQL Server

In this example, you are going to create an external table in a SQL Server instance over the inventory table that sits on an Oracle server. If you are using a SQL Server 2019 big data cluster then the scripts can be executed on the SQL Server Master instance.

Before you begin, you need to have an Oracle instance and credentials. Follow the instruction in the setup\README.md.

Instructions

1. Connect to a SQL Server or SQL Server Master instance.

2. Execute the SQL inventory-oracle.sql.

3. Execute the SQL customer-oracle.sql.