cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Advocate I
Advocate I

CDS Data Integrator Project - Oracle Connections Not available

Hi There, We are setting up a new project under admin.powerplatform.microsoft.com > Data Integration. I have setup a connection to Oracle DB from Data Flow section in make.powerapps.com However, when trying to setup a connection set under Data Integration Project, unable to see newly created Oracle Connection. I can see SQL Connections but not Oracle connections.

 

I can create a Data Flow with the the oracle connection from make.powerapps but not a CDS Data Integration Project in admin.powerplatform.microsoft.com. Is the Oracle connection not supported in CDS Data Integration project? 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Impactful Individual
Impactful Individual

Re: CDS Data Integrator Project - Oracle Connections Not available

Hi @KunalKochhar1 

 

1) I haven't done alternate keys with lookup fields before. But my experience with dataflows has been pretty good, provided I set up the CDS beforehand rather than letting it automatically create my entities. I know lookup is a data type that alternate keys are supposed to support. This sounds like it might need a support ticket.

2) Yeah, there isn't much you can do from there, but it does allow you to monitor your dataflow.

3) If you need tasks to execute in order then I would suggest a more complex integration project in Azure Data Factory.

4) Between needing to use Oracle as a data source, needing to do more than 6000 records and needing to break things into tasks, I really don't think either dataflows or data integrator projects are going to work for you. I think you should consider Azure Data Factory Data Flows.

View solution in original post

4 REPLIES 4
Highlighted
Impactful Individual
Impactful Individual

Re: CDS Data Integrator Project - Oracle Connections Not available

Hi @KunalKochhar1 

 

CDS Data Integration Projects are a couple years old now and are generally better suited for integrated different parts of Dynamics, and in fact I don't even think they can connect to Oracle.

 

You can do your integration in a Dataflow, which will do the same thing, you don't need a corresponding Data Integration Project. In fact, once a Dataflow successfully runs, I believe it even shows up as a Data Project in the admin center.

 

Carina Claesson wrote a good blog post about this back in October that I recommend checking out:

https://carinaclaesson.com/2019/10/16/power-platform-saturday-sweden-from-a-speakers-point-of-view-i...

 

---
Please hit the "Accept as Solution" button if my post answered your question! If my post was helpful please consider giving it a "Thumbs Up."

Highlighted
Advocate I
Advocate I

Re: CDS Data Integrator Project - Oracle Connections Not available

Thanks SKH19. Few issues we found with Data Flow which made us looking at CDS Data Integration Projects, see if you can provide commentary on each of these issues and if they are known to you:

 

  1. The Data Flow was having issues setting up lookup fields with Alternate Key from source. Have you seen this issue before and is there a guidance anywhere on how to set these alternate key fields within Data Flow? In CDS Data Integration Projects this lookup field is available and sets its correctly.
  2. When Creating a Data Flow and if we switch to CDS Data Integration Project the data source is not set in the connection set, it just shows source as Mashup and hence doesn't then allow to do the field mappings. So really it doesn't help having CDS Data Integration Project autocreated from Data Flow
  3. Within CDS Data Integration Project it allows to create Tasks which then executes in order, I am assuming within Data Flow the order of entities mapped is similar? This is going to be critical for setting up the lookup values
  4. Data Flow throttles with an error when it is upserting more thank 6000 records, we were planning to break this in chunks via CDS Data Integration Project Tasks.

Thanks,

Kunal

Highlighted
Advocate I
Advocate I

Re: CDS Data Integrator Project - Oracle Connections Not available

Setting up lookup filed with alternate key gives following error in Data Flow when syncing data:

 

Missing destination field cr931_accountlookup.new_accountlookupnumber in the schema

Highlighted
Impactful Individual
Impactful Individual

Re: CDS Data Integrator Project - Oracle Connections Not available

Hi @KunalKochhar1 

 

1) I haven't done alternate keys with lookup fields before. But my experience with dataflows has been pretty good, provided I set up the CDS beforehand rather than letting it automatically create my entities. I know lookup is a data type that alternate keys are supposed to support. This sounds like it might need a support ticket.

2) Yeah, there isn't much you can do from there, but it does allow you to monitor your dataflow.

3) If you need tasks to execute in order then I would suggest a more complex integration project in Azure Data Factory.

4) Between needing to use Oracle as a data source, needing to do more than 6000 records and needing to break things into tasks, I really don't think either dataflows or data integrator projects are going to work for you. I think you should consider Azure Data Factory Data Flows.

View solution in original post

Helpful resources

Announcements
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

secondImage

Return to Workplace

Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.

secondImage

Super Users Coming in August

We are excited for the next Super User season.

secondImage

Community User Group Member Badges

FIll out a quick form to claim your community user group member badge today!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Users online (9,003)