Joining Excel database with Oracle database 关注

0
Avatar
Dianne Mays

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.

3 评论

-1
Avatar
Dianne Mays
评论操作 固定链接

I seem to have answered my own question.  I put the query in a view and can now join the two databases.

0
Avatar
Eduards Gzibovskis
评论操作 固定链接

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
Avatar
Dianne Mays
评论操作 固定链接

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.

请先登录再写评论。