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