difference b/w Oracle analytic cloud and Developer Client Tool for Oracle Analytics Cloud and Oracl

Question

Summary

What are the differences and what purpose of these tools please advice? Oracle analytic cloud and  Developer Client Tool for Oracle Analytics Cloud and Oracle Data Gateway 105.4 and Analytics Desktop?

Content

Hi All,

I would like to know about Developer Client Tool for Oracle Analytics Cloud and Oracle Data Gateway 105.4 ?

What can we achieve using these tools? I am looking to automate data via data sync tool. Synchronization (loading data from source tables to ADW Cloud) to ADW Oracle autonomous data warehouse.

I am working on Oracle analytic cloud desktop and cloud to build reports and dashboards.

Please advice.

Download:

- OAC_Client_105.4-161

- OAC Data Gateway 105.4 binaries for Windows

- jdk-8u231-windows-x64

- jce_policy-8

Thanks - Rehan

Rehan Irshad · Answer

Thanks Brian for guidence, you get what Im thinking. I am trying and will get back to you if I need further assistance.

Thanks - Rehan

Rehan Irshad · Answer

Thanks Aman for sharing valuable information. I am a learner and get back to you if get any assistance.

Thanks - Rehan

User_6K1A3 · Answer

Hi Rehan,

Aman provides a good description of the tools and what they accomplish.

For your particular use case, you will want to use Data Sync connected to ADW to synchronize your data to the cloud for batch processing needs.  If you need a more real-time replication of on-premises data to ADW, then I would explore the use of Oracle's Golden Gate.  The great thing about utilizing ADW, is that you will not find it necessary to use Data Gateway, unless you are looking to connect to on-premises sources directly from Data Visualization or through the RPD.

I would be happy to discuss with you further if you want to know more about the appropriate architecture setup for your use case(s) and how to take complete advantage of what OAC has to offer.

Thanks,

Brian