What would be awesome is to have a link to ideas from the forum pages https://cloudcustomerconnect.oracle.com/pages/9c5db79a45

It uses the jdbc:oracle:thin driver (oracle.jdbc.OracleDriver) From the DB doc: The JDBC Thin driver enables a direct connection to the database by providing an implementation of Oracle Net Services on top of Java sockets. The driver supports the TCP/IP protocol and requires a TNS listener on the TCP/IP sockets on the…

What is the protocol used between Data Gateway and an Oracle DB?

also, I know you mention you want to use SSIS but ODI is now free on the Oracle Market Place... Food for thought...https://cloudmarketplace.oracle.com/marketplace/en_US/listing/59419903

if your fusion env is 19c I would recommend using Object Storage as the target, rather than UCM, you'll have more options/APIs to connect. This won't trigger the BICC extract though. But I believe there are APIs for that because OAC data replicator uses them to trigger the extract and storage in OCI Object Storage. Hope…

OAC only supports connecting to SQL Server with UserID and Password.

How does Data Gateway connect when the access to the database is relying on Active Directory?

A year ago I asked for an OAC specific section to be added : https://cloudcustomerconnect.oracle.com/posts/e5f1390851 Hopefully under T.K.Anand, and even more under Bruno Aziza, we will see some improvment on the user feedback front...

Unlike with other type of datasets where DVD attempts to recognize column types (and the user can update them afterwards), for Essbase DVD relies fully on Essbase Metadata. All the members of the dimension flagged as Dimension Type = Accounts should show as measures in DVD. Can you double check the outline on the Essbase…

yes that's right and I also learnt the advanced version of it , where we add a BY clause (e.g. Sales/SUM(Sales by Whatever) )

I had not seen the requirement either :-) A colleague told me about it after I had banged my head on the wall for a few hours. I agree that if we can't install DVML with DVD for licensing reasons (which I doubt because getting rid of the GNU licensing constraint was the point beyond moving from R to Pyhton) then they…

have you installed the new DVML thing (and possibly the Advanced Analytics thing too)?

Maybe you can try to download it directly form https://oss.oracle.com/DVML/DVML-1.0.0-win.zip ----------- Nov 02, 2017 5:25:40 PM oracle.bi.exec.ExecScript executeScript INFO: Executing: [C:\PROGRA~1\ORACLE~1\OracleBI1\modules\oracle.bi.configutils\internetproxylookup.exe, https://oss.oracle.com/DVML/DVML-1.0.0-win.zip]…

would make the experience more consistent

showstopper for many customers