Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask here!
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Choose specific table in Connection String to Azure DB

olegvolosnik
5 - Atom

Hello,

my task is simple migration of table from Oracle DB to  Azure DB, with daily schedule. 

I have managed this workflow on my machine and it works. 
Problem is connection to Azure DB visible from Gallery perspective to make possible set schedule. 
As far as I know, the only connection possible from Gallery perspective is ConnectionString:

  odbc:DRIVER={SQL Server Native Client 11.0};UID=_user_;PWD=_pwd_;DATABASE=_db_;SERVER=_server_;

This connection string works, but I can not in any way choose table from Azure DB with output tool.

 

Attached model of my workflow.

 

Could you please give advice how should be modified ConnectionString?

Or should I use another approach for connecting to Azure which allows choose table and set schedule in Gallery?   


Regards, 

Oleh 

1 REPLY 1
olegvolosnik
5 - Atom

Problem was solved by adding table name after tree pipes('|||').
As on example:

 

   odbc:DRIVER={SQL Server Native Client 11.0};DATABASE=_db_;SERVER=_server_;UID=_user_;PWD=_pwd_;|||_tablename_

 

Not sure that order of labels is important but recommend to set as on example.

Labels
Top Solution Authors