Skip to main content
Question

Does anyone know if you can extract data from multiple databases in one extraction?

  • June 15, 2021
  • 1 reply
  • 1 view

Forum|alt.badge.img+7

We have a really complex query that was built out to extract data in flat files, but want to pivot to a direct connection. The query pulls from multiple databases, and we would like to avoid reverse engineering the logic as a large data job. Can we pull from multiple databases in one extraction, so that we can run the query we have built?

1 reply

You need separate connections per database, and extractions for those dbs run differently. You can join all the data in global jobs