Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
MPN
Contributor
Contributor
‎2021-09-17 02:56 AM

Migration of Data from AZURE AD to SQL SERVER Database

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

Labels (2)
Labels
312 Views
4 Replies
Anonymous
Not applicable
‎2021-09-17 09:55 AM

@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.

312 Views
0 Likes
JoelPaulAP
Contributor
Contributor
‎2021-09-17 11:28 AM

In response to Anonymous

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?​

312 Views
0 Likes
Anonymous
Not applicable
‎2021-09-17 12:11 PM

In response to JoelPaulAP

@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

312 Views
0 Likes
JSadasivam1614976104
Contributor
Contributor
‎2023-10-03 04:18 PM

@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.

312 Views
0 Likes