9 Query Semantic Models Remotely Using JDBC

You can query Oracle Analytics Cloud semantic models from an external client tool using a JDBC connection.

Topics

• Overview to Querying Oracle Analytics Cloud Semantic Models Remotely
• Choosing an Assertion Type for Your JDBC Connection
• Typical Workflow to Query Oracle Analytics Cloud Semantic Models Remotely
• Register the BIJDBC Application Using Resource Owner Assertion
• Generate the Client Private Key and Client Certificate File
• Register the BIJDBC Application using JWT Assertion
• Set Up Refresh Security Token
• Download the JDBC Driver
• Connect to Oracle Analytics Cloud Using a JDBC URL
• Example: Connect to a Semantic Model Remotely Using SQuirrel