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?
Question
Does anyone know if you can extract data from multiple databases in one extraction?
You need separate connections per database, and extractions for those dbs run differently. You can join all the data in global jobs
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.