Solved

CommonDataService Connector

  • 9 February 2024
  • 2 replies
  • 41 views

HI Team,

 

Please can you help me understand how to connect TX with common data service connector?

 

I am trying to bring the data from D365 field service to TX. With Power BI i can use common data service connector and extract the data from FS. But i want to use TX to do ETL. Please help!!

icon

Best answer by Thomas Lind 9 February 2024, 12:37

View original

2 replies

Userlevel 6
Badge +5

Hi @jyothi.dosi 

There is a CData provider for it. You choose the one called Dynamics 365 and in that there is an option called edition. It has multiple options and one is FieldService.

I would assume this works for this.

I am guessing you are on v20, but if you are on a SaaS release it looks like this.

 

Here is what is needed to connect.

https://cdn.cdata.com/help/LJJ/ado/pg_connection.htm

You likely need to create an app like you would for the other editions.

https://cdn.cdata.com/help/LJJ/ado/pg_azureadoauthcustomappcreate.htm

We also have a legacy guide for connecting to Sales, which is very similar to how this would be done.

https://legacysupport.timextender.com/hc/en-us/articles/360057331151-Connect-to-Dynamics-365-Sales-CRM-Online

Userlevel 6
Badge +5

Hi @jyothi.dosi 

Were you able to resolve the issue? If so please help us by marking a best answer above. If you have any follow up questions please let us know

Reply