Oracle Cloud SQL Client
Oracle Cloud SQL client - to run adhoc sql queries for OTM/ERP/SCM/HCM cloud to extract data. Currently cloud sql is in beta version Assumptions : 1) User should be able to login with static user name and password (not single signon) PreRequisites: 1) Open JDK 8 or Oracle JDK 1.8 2) Importing XDO file into Cloud XML Publisher instance 3) Permissions for user to access XML Publisher 4) CloudSQL Jar file GitHub Location: https://github.com/csreedhar20/CloudSQL/tree/master Installation Steps : JDK Installation is out of scope and you can refer google for installation steps Importing XDO file into Cloud XML publisher : (One time setup per instance) 1) Download CloudSQLDM.xdoz and CloudSqlReportCSV.xdmz files into desktop from github 2) Create new folder name "Test" inside Custom folder 3) Upload CloudSQLDM.xdoz and CloudSqlReportCSV.xdmz files to xmlpserver (screen shot above once uploaded) 4) In BI Publisher, give full control as shown below for CloudSQLDM and CloudSqlReport...