Select to view content in your preferred language

Help with SQL statement for make query layer

601
2
Jump to solution
01-22-2019 01:23 PM
JamesJudge
New Contributor II

I'm trying make a query layer using tabular information in an Oracle database and a parcel centriod point file. The SQL query I'm using is not working and the error seems like the oracle table is not being found.

Attached is my SQL statement and error message

Tags (1)
0 Kudos
1 Solution

Accepted Solutions
JoshuaBixby
MVP Esteemed Contributor

You are trying to join tables that are not only in different databases, but different DBMSes.  Although doing such a query is possible in the DBMS realm, it requires linked servers to be configured correctly.  Are you sure either the Oracle or SQL Server database is configured correctly to support a database link to the other?

View solution in original post

2 Replies
JoshuaBixby
MVP Esteemed Contributor

You are trying to join tables that are not only in different databases, but different DBMSes.  Although doing such a query is possible in the DBMS realm, it requires linked servers to be configured correctly.  Are you sure either the Oracle or SQL Server database is configured correctly to support a database link to the other?

JamesJudge
New Contributor II

I now understand that we need to setup the linked Oracle DB to create a view with the two databases.

0 Kudos