Learn how to set up an OpenID Connect Namespace with Snowflake data server connection from Cognos, configured with an OKTA IDP with SAML 2.0 compliant service/application for federated authentication from Active Directory with this easy step-by-step guide.
By following the instructions, you'll be able to seamlessly connect your Snowflake data server to your Cognos environment using your existing OKTA IDP credentials. This will ensure secure and efficient data access for your team while also simplifying your authentication processes.
Active Directory Domain Controller
OKTA provider Integrated with Active Directory
On-Premise: Cognos Analytics 11.2.4
This blog outlines the steps required to successfully connect Cognos Analytics to a Snowflake data server using federated authentication from Active Directory.
The following steps outlined below will be covered in this blog post:
- How To Set up the OKTA IDP service/application and ensure it is configured for SAML2.0 authentication.
- How To Integrate Active Directory with the OKTA SAML2.0 application
- How to Create SECURITY INTEGRATION between Snowflake and OKTA.
- How To Create a data source connection in Cognos Analytics with Snowflake
- Testing the data source connection in Cognos Analytics using Active Directory configured for Federated authentication with OKTA
The results should indicate a successful connection to the Snowflake data server with federated authentication through the IDP service/application.
A.Configuration OKTA with Snowflake Application
1. Create a Snowflake application in Okta from Application-->Browse App Catalog