You can't. There's no way to connect directly to the Fusion cloud DB itself. If you're looking to extract data - then look at the BI Cloud Connector. This can be scheduled to create extracts, which ODI can then consume.…

data models aren't published. The best you'll probably get is via this link. So go to docs.oracle.com - and then click down this path. For you HCM. You can then download spreadsheets which list all the view objects available for BI Cloud Connector extracts. Those include the table / field names. So if you use this - maybe…

OAC = Oracle Analytics Cloud Similar to a full OBIEE in the cloud (with a few exceptions). It has full delivers capability, unlike BICS. Unlike BICS - it's a customer managed solution, so the customer will do patches etc - and has the ability to get to the operation system of the VM, tweak config files, just like you could…

Are you talking about doing this in BI Cloud Service ? If yes - then no. It's a very limited 'delivers' and you can't send to SFTP. Maybe you could do something within your e-mail client to set up a rule from a particular sending / subject, and then save the attachment to a local folder - and then have a tool that pushes…

it's not. Best you could probably do is use another service / process to call the service first and pull back the data to the local file system, then have data sync consume that.