Skip to main content
Solved

CommonDataService Connector

  • February 9, 2024
  • 2 replies
  • 114 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!!

Best answer by Thomas Lind

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

2 replies

Thomas Lind
Community Manager
Forum|alt.badge.img+5
  • Community Manager
  • 1161 replies
  • Answer
  • February 9, 2024

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


Christian Hauggaard
Community Manager
Forum|alt.badge.img+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