Connector for Active Directory - examples

Hi ​@anders.bengtsson 

I better add my response here as well.

In the old program, we would do it with OLE DB provider pointing at the Microsoft Directory Services provider.

 
If you search for Active Directory in the portal you have two options REST and the one from above.

For the old setup, I also had to use queries like this to make it work.

You can make similar queries in the Query table tool. You will not see any tables when you run the Manage Metadata Sync task before you have done this.

Hi ​@anders.bengtsson does the above comment answer your question? Please let us know if you have any follow up questions

Is there an example of the new Microsoft Ole DB provider for directory services? I have the connection properties of the old situation, but donb't know how to transfer this one to the new one…

Regards,

Guido

​@GuidoRitzen which version of TimeXtender are you using?

In TimeXtender 20.10 you can add Any Source OLE DB providers in the Business Unit:

In TDI you can use the below provider, or private data source

Please let me know if you have any follow up questions

Hi Christian,

I'm using (cloud) TimeXtender Data Integration version 6848.1

I don't no what information I need to fill to connect to the on prem AD:

An example would be great.

Regards,

Guido

​@GuidoRitzen can you please send a link to download/documentation for the Microsoft Ole DB provider for directory services?

https://learn.microsoft.com/en-us/office/client-developer/access/desktop-database-reference/microsoft-ole-db-provider-for-microsoft-active-directory-service 

​@GuidoRitzen thanks do you have the download link?

I did it via TX Data Integration. Tools > Add Private Data Source > OLE DB…

Like you suggested above.

Maybe better to have a short call?

Hi ​@GuidoRitzen please send the download link. If the provider needs to be downloaded and installed before it can be used so this is the first step

I don't get it. It is all standard TimeXtender, I didn't download anything...

​@GuidoRitzen 

The provider you are referring to is not a standard TimeXtender provider. It is an external OLE DB driver which TimeXtender can connect to.

For example if I want to use the below SQL OLE DB provider (in this example it is SQL provider but it could also be another OLE DB provider such as the one you mention)

https://learn.microsoft.com/en-us/sql/connect/oledb/download-oledb-driver-for-sql-server?view=sql-server-ver16

Then I would download the driver and install it, and then create a udl file (make a text file and rename it to include the udl extension e.g. filename.udl)

Then I double click on this file, choose the provider and fill out the necessary connection settings and click OK.

In the TDI portal, create the OLEDB data source and point to the UDL file

Please let me know if I have misunderstood something, or if you have any follow up questions