Skip to main content
Solved

CommonDataService Connector


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

View original
Did this topic help you find an answer to your question?

2 replies

Thomas Lind
Community Manager
Forum|alt.badge.img+5
  • Community Manager
  • 1017 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


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings