Your Browser is Out of Date

Nytro.ai uses technology that works best in other browsers.
For a full experience use one of the browsers below
Design Guide — Oracle Big Data SQL on Dell EMC PowerFlex
Introduction Solution architecture Solution components Phase I: Infrastructure design and deployment Network design Phase II: Storage design Phase III: Oracle 19c database design and deployment Hadoop cluster design and deployment Configuring Big Data SQL Oracle NoSQL design and deployment Microsoft SQL Server design and deployment Oracle Gateways design and deployment Generate and load data
Generate and load data
Installing and loading TPCH data using DBGEN
Cleaning the data
Loading TPCH data in Oracle NoSQL
Loading TPCH data in Hadoop
Loading TPCH data into the Oracle database
Loading TPCH Schema on Microsoft SQL Server
Creating Oracle external tables pointing to Oracle NoSQL kvstore
Creating Oracle external tables pointing to HDFS
Accessing Microsoft SQL Server tables using Oracle Gateways
Data virtualization with Big Data SQL
References Appendix A

Accessing Microsoft SQL Server tables using Oracle Gateways

Accessing Microsoft SQL Server tables using Oracle Gateways

  • After you configure Oracle Gateways, create database links on the Oracle database to access the tables on Microsoft SQL Server. Create the database links using these steps:

    1. Create database links from Oracle database to Microsoft SQL Server to access tables using the following command:

    SQL>CREATE PUBLIC DATABASE LINK dblink CONNECT TO sqluser" IDENTIFIED BY "sqlpassword" USING 'dg4msql';

    1. After creating the database link, verify the connection to Microsoft SQL Server with this command:

    SQL>SELECT * FROM DUAL@dblin