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
Solved! Go to Solution.
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.