4 Connect to Data for Pixel-Perfect Reports
This topic describes how to connect to data sources for creating pixel-perfect reports using Publisher.
Topics:
- Overview to Connecting to Data Sources for Pixel Perfect Reports
- About Private Data Source Connections
- Grant Access to Data Sources Using the Security Region
- About Proxy Authentication
- Choose JDBC or JNDI Connection Type
- About Backup Databases
- About Pre Process Functions and Post Process Functions
- Set Up a JDBC Connection to a Data Source
- Set Up a Database Connection Using a JNDI Connection Pool
- Set Up a Connection to an OLAP Data Source
- Set Up a Connection to a Web Service
- Set Up a Connection to an HTTP Data Source
- Set Up a Connection to a Content Server
- Set Up a Connection to a Snowflake Data Warehouse
- View or Update a Connection to Data Source
- Set Up Key-pair Authentication to Snowflake Data Warehouse
Set Up Key-pair Authentication to Snowflake Data Warehouse
Connect Analytics Publisher to Snowflake Data Warehouse using key-pair authentication.
Before you begin:
- • Generate a Snowflake public/private key pair and retain the private key securely.
- • Add the public key to the target Snowflake user before configuring Publisher.
- • Have the Snowflake JDBC connection string and service-user name ready.
- • Use a Publisher administrator account with access to Upload Center and JDBC data sources.
Troubleshooting
- Private key is not listed - Verify that the file was uploaded in Upload Center with File Type set to SSH Private Key. Refresh the data-source page after the upload.
- Authentication fails - Confirm that the public key registered on the Snowflake user matches the uploaded private key and that the correct Snowflake username is supplied.
- Encrypted key fails - Re-enter the private-key passphrase in the Password field. Leave the field blank only for an unencrypted private key.
- Connection test fails - Validate the Snowflake JDBC URL, account/network reachability from the OAC environment, warehouse/database/schema access, and Snowflake user permissions.