Uploaded November 2026 | Updated November 2026, 4 days ago
Learn how to upload the Microsoft SQL Server JDBC driver and certificate to IBM Cognos Analytics as a Service on AWS, create a data server connection, and verify that it works.
In this step-by-step demo, learn how to configure Microsoft SQL Server connectivity in IBM Cognos Analytics as a Service. The walkthrough covers the complete process, from preparing and uploading the supported JDBC driver and certificate authority (CA) certificate to restarting the required services, creating a data server connection, and validating the connection.
Prerequisites:
• Configure a private connection if your SQL Server database does not have a public endpoint. This is covered in a separate video.
• Have the supported Microsoft SQL Server JDBC driver files ready. Check the IBM documentation for the driver version tested with your Cognos Analytics release.
• Have the CA certificate that signed your SQL Server certificate ready.
In this walkthrough:
• Identify the supported Microsoft SQL Server JDBC driver version for your IBM Cognos Analytics release.
• Upload the JDBC driver files under Artifacts on the Instance Management page.
• Upload the CA certificate by selecting the Certificates artifact type.
• Restart the Data, Smart, and REST services under Cognos Workloads to load the driver and certificate.
• Create a new Microsoft SQL Server data server connection using a JDBC URL under Manage - Data Server Connections.
• Test the data server connection to verify connectivity.
• Load the SQL Server schemas and tables as assets in IBM Cognos Analytics.
This walkthrough demonstrates how to configure a Microsoft SQL Server JDBC connection in IBM Cognos Analytics as a Service on AWS, including driver installation, certificate configuration, and connection validation.
Learn more about IBM Cognos Analytics:
ibm.com/products/cognos-analytics
If you found this tutorial useful, like the video and subscribe for more IBM Cognos Analytics demos and technical walkthroughs.
#IBMCognos #CognosAnalytics #sqlserver
#DriverUpload
#jdbc #businessintelligence #ibmcloud #SaaS
Learn how to upload the Microsoft SQL Server JDBC driver and certificate to IBM Cognos Analytics as a Service on AWS, create a data server connection, and verify that it works.
In this step-by-step demo, learn how to configure Microsoft SQL Server connectivity in IBM Cognos Analytics as a Service. The walkthrough covers the complete process, from preparing and uploading the supported JDBC driver and certificate authority (CA) certificate to restarting the required services, creating a data server connection, and validating the connection.
Prerequisites:
• Configure a private connection if your SQL Server database does not have a public endpoint. This is covered in a separate video.
• Have the supported Microsoft SQL Server JDBC driver files ready. Check the IBM documentation for the driver version tested with your Cognos Analytics release.
• Have the CA certificate that signed your SQL Server certificate ready.
In this walkthrough:
• Identify the supported Microsoft SQL Server JDBC driver version for your IBM Cognos Analytics release.
• Upload the JDBC driver files under Artifacts on the Instance Management page.
• Upload the CA certificate by selecting the Certificates artifact type.
• Restart the Data, Smart, and REST services under Cognos Workloads to load the driver and certificate.
• Create a new Microsoft SQL Server data server connection using a JDBC URL under Manage - Data Server Connections.
• Test the data server connection to verify connectivity.
• Load the SQL Server schemas and tables as assets in IBM Cognos Analytics.
This walkthrough demonstrates how to configure a Microsoft SQL Server JDBC connection in IBM Cognos Analytics as a Service on AWS, including driver installation, certificate configuration, and connection validation.
Learn more about IBM Cognos Analytics:
ibm.com/products/cognos-analytics
If you found this tutorial useful, like the video and subscribe for more IBM Cognos Analytics demos and technical walkthroughs.
#IBMCognos #CognosAnalytics #sqlserver
#DriverUpload
#jdbc #businessintelligence #ibmcloud #SaaS










