Dataflow union statements odbc

[StephenF]

Dataflow insists on 4 connections for the scheduler even though there is only one connection needed.

I think this is because there is a 4 queries connected by union statements in the select statement in the odbc window.

How to fix so there is only one connection required in the scheduler?

[Anonymous]

Hi @StephenF ,

Please provide more details.

May I know whether you are using ODBC connector to connect your data source to create a dataflow. If so, What is your data source ? If your meaning is using Union to connect 4 tables and change them to one table? 

"Only one connection required in the scheduler" , does it mean there are four gateways need to configure under 4 data sources?

If I misunderstand your meaaaning, please contact me with more information.

Best Regards

Community Support Team _ Polly

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.