user2860954
user2860954

Reputation: 175

I am a newbie to DMBS system is it possible to join two Database Systems like SQL and Netezza?

Is it possible to join two tables from different database systems such as SQL and Netezza using any query language.

Specifically is it possible to achieve a join in AQT.

Is it possible for a tool like AQT ( Advanced Querying Tool) to provide a platform which allows us to connect the tables from these different database systems

Upvotes: 0

Views: 50

Answers (1)

Uday
Uday

Reputation: 21

You can try creating linked server in SQL. But doing so have an overhead on the SQL server from DBA point of view. You need extra privileges to create a linked server.

Upvotes: 1

Related Questions