How to Fetch Data from Oracle Primavera Cloud to Microsoft Fabric Warehouse

[Jitendra123]

Not able to load data from Oracle Primavera Cloud to Fabric Warehouse, what method or what path i shoud choose, 

Help with any documentation or suggetion 

[FabianSchut · Accepted solution]

Hi, it seems that your source has an API available to extract data to the Fabric. The documentation for Oracle can be found here: https://docs.oracle.com/cd/E80480_01/English/integration/data_service_reference_guide/D149289.html

You could use different methods to use the API, like copy data in a pipeline, dataflow gen2 or custom notebooks. If you want to use copy data, you can take a look at this documentation: https://learn.microsoft.com/en-us/fabric/data-factory/connector-rest-copy-activity. I prefer notebooks in these cases for more flexibility. Here's an example of a Python script to use an API: https://www.datacamp.com/tutorial/making-http-requests-in-python