Symptom
Oracle 19c does not appear in the ".properties" file when attempting to import a data connection to an SQL database in SAP Analytics Cloud.
Environment
- SAP Analytics Cloud.
- Reporting DB: Oracle 19C
Reproducing the Issue
1. Install and configure The Cloud Connector.
2. Install and configure SAP Analytics Cloud agent.
3. Install JDBC drivers.
4. Create a ".properties" file that specifies the paths to JDBC drivers
>> Notice that the Oracle 19c is not listed in the ".properties" file example.
Cause
Oracle 19c is not supported to be used in SAP Analytics Cloud.
Resolution
- An enhancement Request has been created: https://influence.sap.com/sap/ino/#/idea/325553
SAP is committed to reviewing and responding to the ideas submitted on a regular basis. The ideas with the most votes will receive a higher level of attention for response and consideration. The processes and procedures associated with this site will continue to evolve and enhance over time. Refer to Knowledge Base Article for more details: 1515837.
- Possible workaround is to use 'Generic JDBC Datasource' option for creating the connection.
See Also
- KBA: 1515837 - How To: Enhancement Request Process using the Customer Influence and Adopt site.
- KBA: 2606346 – What are the system requirements and technical prerequisites for using SAP Analytics Cloud?
- Import Data Connection to an SQL Database.
Keywords
Import Data Connection, SAC, Oracle 19c, Compatibility. , KBA , LOD-ANA-AQU , Import Data Connections (Acquiring Data) , Product Enhancement