Oracle Primavera: API Integration from GCP

[fbermeoq]

Hi all

We must to integrate with Oracle Primavera through their API REST from GCP.
The official documentation is the following: https://docs.oracle.com/cd/E80480_01/English/integration/data_service_reference_guide/D149289.html
Based on your projects experiencie. ¿Which is the best option of GCP service to implement an integration solution?

Thanks in advance for your guidance

[anjelab]

Can you elaborate your objective? Also, which GCP cloud service were you connected or want to connect?

[fbermeoq]

Hi

The idea is to extract data from many entity tables using for instance Cloud Dataflow as Batch Integrator. The data must be storage on BigQuery tables. ¿Which GCP service you recommend to implementar that process?

[anjelab]

Google-recommended service for that is Cloud Data Fusion. Cloud Data Fusion is a fully managed, cloud-native, enterprise data integration service for quickly building and managing data pipelines.

You may follow these steps on creating a replication job from Oracle to Bigquery. 

[fbermeoq]

Hi  @anjelab 
The Oracle database is not the direct data source. The data extraction must be through their API REST as I mention in my first post: https://docs.oracle.com/cd/E80480_01/English/integration/data_service_reference_guide/D149289.html