APIs to extract data from Aconex (Oracle Database) to Azure SQL database to report using Power BI.

[Anonymous]

Hi Community,

We want to report on Aconex data in Power BI

Aconex is now owned by Oracle and the underlying database is Oracle.

I want to bring in Aconex Field data from Aconex to Azure SQL database to report using Power BI.

I wouldn't mind reporting directly off the Aconex Oracle database if there is a way to connect Power BI directly. I tried it a few months ago but didn't work though I got the Web Services API Developer and Activation Keys. Or, please throw some light for me to check if I missed any steps in trying to connect properly!

I am looking for any guidance to help me design the APIs myself to ETL data as below 3 options whichever is easier to do so:

1. Aconex Oracle database -> Power BI

2. Aconex Oracle database -> Azure SQL database -> Power BI

3. Aconex Oracle database -> Open to any better storage in Azure -> Power BI

Any help/guidance on how to achieve this is greatly appreciated.

Any info with screenshots or guidelines would be of great help to me and others in a similar situation.

Hoping to hear soon.

Thanks a million for your time in advance.

Regards,

Chandu

[SteveCampbell]

I would suggest data factory.


Go to portal.azure.com. Set up you sql database first.

search for data factory and start a new one. Go to author and monitor, then set up a new pipeline.
Set up connections to Oracle and your Sal database.
Add “copy data” and set the source to oracle and the sink to sql.

To get you started:
https://docs.microsoft.com/en-us/azure/data-factory/quickstart-create-data-factory-copy-data-tool#st...

Connecting to oracle
https://docs.microsoft.com/en-us/azure/data-factory/connector-oracle