Need to Incremental push records from on-premise SQL to Azure Data lake - AX2012

(0) Share

Report

Posted on by kvigneshvaran

Hi,

Am trying to load the on premise SQL DB tables to Azure Data lake.

i have created the corresponding linked services and exported the data from SQL DB to Azure Data Lake.

Now i need to load the incremental push records. This one also i have achieved using change tracking technology. (using Azure Data factory i have done this, any other recommended solutions also acceptable).

Now both files are seperate files in Azure Data Lake.

How i need to update the incremental push records into an existing file without disturbing the other records which are not modified.

Because if am trying to merge those two files and it will create the new seperate file only. So finally extra data count occurs (data which are not modified also need to write the new file).

So is there any way to push the incremental records in the existing file without disturbing the unmodified records in existing file.

All responses (1)

Answers (1)

Verified answer

André Arnaud de Cal... 294,261 Super User 2025 Season 1 on at

Like (0)

Report

RE: Need to Incremental push records from on-premise SQL to Azure Data lake - AX2012

Hi kvigneshvaran,

Your database might contain data from a Dynamics AX environment, but your question itself is not related to the contents of this Dynamics AX forum. You can better ask your question on the Azure Data Lake Analytics forum: social.msdn.microsoft.com/.../home