Forum Discussion

StephenF's avatar
StephenF
Responsive Resident
4 years ago

Dataflow union statements odbc

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?

 

 

Dataflow

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    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.