Skip to Content
avatar image
Swetha N

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

Oct 22, 2017 at 12:34 PM | 87 Views | Last edit Oct 22, 2017 at 12:35 PM 2 rev.

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 ]

SAP Data Services
bods | dataflow | sql transform | how to | suggestion | tips
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Ravi kiran Pagidi
    Oct 23, 2017 at 12:02 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded