Customer experience | Sales, Customer Insights,...

Finance and operations to Customer insights

(0) Share

Report

Posted on by Community Member

Hi i tried to send data from finance operatons to Customer insights but I didn't succeed, i tried passing by dual write or power plateform and nothing

Does anyone did it already can help me?

Thank you in advance

All responses (4)

Answers (0)

Suggested answer

John Wiese on at

Like (0)

Report

RE: Finance and operations to Customer insights

There are two ways to do what you want to do, you can either use the OData connector and hit the OData endpoints for F&O or you can use the dual-write capability to write the F&O data out to the dataverse storage and then use the direct connection (Connect to Common Data Service) or the Dataverse connector when it is released.
Suggested answer

Bill Ryan 8 on at

Like (0)

Report

RE: Finance and operations to Customer insights

The OData Connector docs.microsoft.com/.../odata (bottom right corner). I believe this is a trial but if you wanted to, writing a quick ADF pipeline to drop this over as a Parquet file and ingesting the file directly might be an option to. I think you can create a DataFlow as well and use Power Plaform Data Flow to ingest
Community Member on at

Like (0)

Report

RE: Finance and operations to Customer insights

Yes that's what i want to do. here's my connectors
Bill Ryan 8 on at

Like (0)

Report

RE: Finance and operations to Customer insights

Not nitpicking any terms, I just want to make sure I understand the Ask.

You're trying to use F&O data as a source of ingestion in CI, is that right? You should be able to just connect directly using the OData Endpoint provided by F&O. As far as Dual-Write, that's just essentially plugins copying data between systems, if it's copied to CRM so it should be there with the DataVerse connector. Just to be clear, you're selecting Data->Data Sources - Adding a new one and choosing power Query right?