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

Anonymous — Wed, 29 Jan 2020 23:22:46 GMT

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

Re: APIs to extract data from Aconex (Oracle Database) to Azure SQL database to report using Power B

SteveCampbell — Thu, 30 Jan 2020 00:09:37 GMT

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#start-the-copy-data-tool

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

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

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

Re: APIs to extract data from Aconex (Oracle Database) to Azure SQL database to report using Power B