Upload MSSQL JDBC Driver & Create Data Server Connection in IBM Cognos Analytics as a Service on AWS @IBMProductHub
Upload MSSQL JDBC Driver & Create Data Server Connection in IBM Cognos Analytics as a Service on AWS  @IBMProductHub
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
Upload MSSQL JDBC Driver & Create Data Server Connection in IBM Cognos Analytics as a Service on AWSAgentic Administration with IBM App ConnectUpload Oracle Driver and Create Data Server Connection in IBM Cognos Analytics as a Service on AWSDb2 Genius CLI: Custom Slash CommandsHow WatsonX AI Accelerates QRadar Offense InvestigationsHow to Optimize SIEM Storage Costs Using IBM QRadar Tiered StorageTrack & Revert Detection Logic using IBM QRadar Rule VersioningHow to Monitor Real-Time Data Ingestion in IBM QRadarIBM Data Replication CDC: Replicating data from Db2 z/OS (remote source) to DatabricksExplore data end to end with the Agentic Data IntelligenceIBM RPA - FIPS 140-3 supportDb2 CaaS 11 Monitor Profiles
IBM Product Hub |

Upload MSSQL JDBC Driver & Create Data Server Connection in IBM Cognos Analytics as a Service on AWS

SHARE TO X SHARE TO REDDIT SHARE TO FACEBOOK WALLPAPER