It is not supported to use a Data Management Gateway from a custom activity to access on-premises data sources. Currently, gateway supports only the copy activity and stored procedure activity in Data Factory. So, suggest staging your data from ADLS to azure storage using custom activity and then coping your data from storage table to oracle table using copy activity. Tuesday, April 11, 2017 2 ...
The problem is when you deploy your data factory via powershell, for some reason it's expecting a gateway object before it can continue. It works if you deploy through the portal (at least for DB->DB, haven't tested API -> DB)
I am creating a linked service to a remote server in Azure Data Factory v2. The remote server uses username-password authentication mechanism. I have already created a linked service to the same server using username and password both in the linked service creation window and its working fine. I would like to store the password as a secret in Azure Key vault and access that secret from Azure ...
I would now like to be able to transfer all the tables in a database from SQL to blob storage. While defining my dataset for this, I noticed that there wasn't a way to define all the tables in the same JSON file.
Summary: REST data source resulting in json that needs to be transferred into an on premises SQL environment. I'd like one table per array object. I've got the REST pull working fine and can drop it into a json blob. Sample of the json at bottom.
But When I trigger my batch job from Azure Data Factory, I got error: Task failed "Container-enabled compute node requires task container settings" I know we need to pass the parameters like "Image name" to a task like the following:
Ok. I get it. Thanks for checking that out. Now back to part of the original question. I could not find any way to turn off case-sensitivity within the "copy data activity". Is there a way to turn off that case-sensitivity so that a column named MyField will be matched successfully with a column named myField?
I already created Alternate key having combination of two columns in D365 on the said entity and made sure of setting them in Copy Data Activity. But still it is going and creating the existing record.
