bods: how to use tables from different host in a single sql trasform?

[former_member186160]

hi all,

Please suggest on how to use two tables from different host[server] within a single sql transform ?

[to be specific- two tables coming from different datastores ]

[former_member208402 · Accepted solution]

Hi Swetha N,

SQL pushes down SELECT to database and if you join tables from different servers and it will throw error as in SQL transform you will give Datastore name in which the tables exists. So you have 2 options

1. load those 2 tables data to a common staging data and do join.

2. Try creating Database links and use SQL tarnsform to join the 2 tables using database links in SQL transform ( I never tried this and im not sure if this will work out, Just try it yourself and see if it works)

Thanks,

Ravi kiran.