topic Migration of Data from AZURE AD to SQL SERVER Database in Talend Studio

Migration of Data from AZURE AD to SQL SERVER Database

MPN — Fri, 15 Nov 2024 23:43:40 GMT

Hi,

My requirement is to move or migrate the data which is in AZURE AD (Active Directory) to Microsoft SQL Server Database using Talend. Normally to migrate data from AD (Active Directory) we use TLDAPINPUT component but in my case the AD belongs to AZURE which is AZURE AD. I am not sure how to start or which component to be used.

I am using Talend Open Studio version 6.4

Can someone please provide a solution for this

Regards,

Mithil

Re: Migration of Data from AZURE AD to SQL SERVER Database

Anonymous — Fri, 17 Sep 2021 13:55:01 GMT

@Mithileash PN I believe that support for this came with version 7.3 of Data Fabric. It is not available in the TOS edition.

https://help.talend.com/r/en-US/7.3/azure-storage-table/tazurestorageconnection-standard-properties

However, if you are able to write some Java, you may be able to use this....

https://docs.microsoft.com/en-us/java/api/overview/azure/activedirectory?view=azure-java-stable

A major benefit of Talend is that if it is not supported out of the box, you can usually write some that will do it with a bit of Java.

Re: Migration of Data from AZURE AD to SQL SERVER Database

JoelPaulAP — Fri, 17 Sep 2021 15:28:11 GMT

Thanks rhall!!! Do we have any procedure on how to download 7.3 and also do we have any documents on how to connect azure AD?

Re: Migration of Data from AZURE AD to SQL SERVER Database

Anonymous — Fri, 17 Sep 2021 16:11:39 GMT

@Joel Paul if you are using the TOS version, 7.3 TOS won't have this functionality. It has arrived with a patch in 7.3 of the paid version. It *might* be available in the 7.4 milestone version that has recently been released. Here is a link to the ESB version (which does everything DI does and has web service functionality).....

https://sourceforge.net/projects/talendesb/files/Talend%20Open%20Studio%20for%20ESB/7.4.1M11/TOS_ESB-20210708_1030-V7.4.1M11.zip/download

It should be noted that this is a milestone edition, so there may be a few bugs in it.

The top link I posted talks about the configuration options for connecting to Azure AD.

Regards

Richard

Re: Migration of Data from AZURE AD to SQL SERVER Database

JSadasivam1614976104 — Tue, 03 Oct 2023 20:18:04 GMT

@Joel Paul Where you able to accomplish this with the solution provided. I have a similar requirement and wanted to see how you got this working.