I'm new to Toad Data Point and SQL. I am trying to do a cross connection query and all of my research has pointed me towards a cross connection query builder. They point me towards the tools menu > Query Builder > Cross Connection Query Builder. Unfortunately, I don't have that option available. I only see Query Builder.
I have Toad Data Point 5.07.106 (64-bit) and the two databases I need to connect to are Microsoft SQL Server DBs.
What am I missing?
Also, while I'm at it and since I'm new, I might as well explain what I'm trying to accomplish in case I'm way off target here. Database A (We'll call it) is production database. Database B has temp table I use to upload a list of unique identifiers. I need to see if these unique identifiers appear in Database A and if so bring back some of the columns. Databases are on different servers.