Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
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