I am new to Azure DataFactory. I'm creating a pipeline and wish to connect to table via linked service. I've created a linked service to the DB - the connection is successful. When i try to create a Dataset with…
I am facing very simple problem of not able to change the datatype of additional column in copy activity in ADF pipeline from String to Datetime I am trying to change source datatype for additional column in mapping using JSON…
I am building an Azure Data Factory. Inside a Data Flow I have an array of strings. That array of strings I wish to merge into one single string. ie. [ "value1", "value2" ] into "value1, value2" Is that even…
I am trying to get data from Dynamics in my Data Factory, but somehow I'm not seeing column output when I try to use the dataset in my Data Flow. When I use the 'Preview data' option in my Dynamics…
I am new to ADF and I am trying to call a Rest API that is paginated. I have my base url in my dataset as https://mydomain.syncromsp.com/api/v1/tickets?api_key=key_value. I am able to return the first page as seen in the image…
I need to do a full extract (SELECT * FROM) on i series DB2 database. I am using Copy Activity which fails on the source extract due to special character encodings: Error code 2200 Failure type User configuration issue Details…
I am trying to setup an integration to shopify using azure data factory since there is a shopify preview connector, however i cannot establish the linked service. I keep getting a cannot resolve hostname error. I am able to create…
I am reaching out to you gather best practices around ingestion of data from various possible API's into a Blob Storage. I am considering to interface with all the various possible API's using Data Factory and here are the possible…