Joining Excel database with Oracle database
Using Bartender designer 2016. Version is 11.0.8.3153 (64-bit).
I need to use an excel sheet with a list of container IDs and join to an Oracle database with info about those containers. I create the database connection for the excel and then add the new record set which uses an existing named database connection that I have working on other templates, using a custom SQL that I also know works on other templates.
When I go to Multi-database join the two, the left operand and the right operand both show the excel sheet name and fields only and neither shows the Oracle query fields. Any suggestions? Do I have to turn my query into a view so it only reads as one "table"?
I read some posts about problems with Excel but I can't find them again.
-
I seem to have answered my own question. I put the query in a view and can now join the two databases.
-1 -
I have the similar issue, connected txt database and a Microsoft SQL Server. Txt File shows all the fields, whereas the SQL does not show any fields.
What do you mean by: I put the query in a view and can now join the two databases ?
0 -
I created a view in my Oracle database that contains the query i needed. Then i created a query against the view name in the SQL statement.
0
Bitte melden Sie sich an, um einen Kommentar zu hinterlassen.
Kommentare
3 Kommentare