ptoms's avatar
ptoms
Regular Visitor
4 years ago
Status:
Done

DataFlow - Gateway Connection Not Detecting automatically

I am an admin to an enterprise gateway.
We have created an ODBC gateway connection, and, when creating a dataflow using the ODBC connector, when the DSN name is input the gateway connection is not detected automatically. 

Expected Behaviour - Once the DSN is input, the gateway connection, username and password are automatically populated. 
Anonymous. 

 

Gateways

6 Comments

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Dear MS Team,

     

    Please help us with this issue. We have multiple of developer unable to resume their developemendue to this.

    All have sufficient access to use the Gateway connection, however the Gateway is not detected when creating the Dataflow. OP and I as Gateway Admins too are seeing same behaviour  

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    I believe the connection string is case sensitive

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Anonymous Yes, we are using the correct cases. Still the issue persists

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi ptoms ,

     

    This has been determined internally to be an unknown feature limitation.

    For now the work around would be to either write out a full connection string (eg. `driver={foo};server=svr;schema=ignored`), or include your wanted schema value as part of the DSN.

     

    Best Regards,
    Community Support Team _ Caitlyn

     

Completed Ideas