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