Forum Discussion

dramnath_1981's avatar
dramnath_1981
Frequent Visitor
5 years ago

SQL query using tables from Query Editor

Hi,   I have one table from the Oracle database and the other one from the SQL database. Since these are 2 different databases, in "GET DATA" I need to choose 2 different connections like MYSQL & O...
Need Help
DataInsights's avatar
DataInsights
Icon for Super User rankSuper User
5 years ago

Hi dramnath_1981,

 

You may want to create a linked server (see article below). An example is creating a linked server in a SQL Server database that points to an Oracle database. Then you can write SQL that will query tables in each database. You can use the OPENQUERY function in SQL Server to send PL/SQL to an Oracle database.

 

https://docs.microsoft.com/en-us/sql/relational-databases/linked-servers/linked-servers-database-engine?view=sql-server-ver15