Connecting IBM COGNOS to fabric data warehouse

[joachimejans]

Has anyone tried yo connect cognos IBM analytics to a fabric data warehouse? We recently migrated our MS sql server to a fabric data warehouse but I don't know how to redirect the Cognos framework model? 

[psingh1]

Can you respond with steps considering Cognos On-Prem servers are linux OS based?

[v-csrikanth]

Hi @joachimejans 

I wanted to follow up since I haven't heard from you in a while. Have you had a chance to try the suggested solutions?
If your issue is resolved, please consider marking the post as solved. However, if you're still facing challenges, feel free to share the details, and we'll be happy to assist you further.
Looking forward to your response!

Best Regards,
Community Support Team _ C Srikanth.

[v-csrikanth]

Hi @joachimejans 

We haven't heard from you since last response and just wanted to check whether the solution provided has worked for you. If yes, please Accept as Solution to help others benefit in the community.
Thank you.

If the above information is helpful, please give us Kudos and mark the response as Accepted as solution.
Best Regards,
Community Support Team _ C Srikanth.

[v-csrikanth]

Hi @joachimejans 

It's been a while since I heard back from you and I wanted to follow up. Have you had a chance to try the solutions that have been offered?
If the issue has been resolved, can you mark the post as resolved? If you're still experiencing challenges, please feel free to let us know and we'll be happy to continue to help!
Looking forward to your reply!

Best Regards,
Community Support Team _ C Srikanth.

[v-csrikanth · Accepted solution]

Hi @joachimejans 
Please find the steps to connect the IBM cognos in Fabric.

1. Open your Fabric Data Warehouse in Microsoft Fabric and copy the SQL connection string and database name from the “SQL connection” settings.

2. On the Cognos server, install ODBC Driver 18 for SQL Server (or later) if it's not already installed.

3. Open "ODBC Data Sources (64-bit)" and create a new System DSN using the driver. Set the server as the Fabric SQL endpoint, choose SQL authentication, enable encryption, and trust the server certificate.

4. In the Cognos Administration portal, go to Configuration > Data Source Connections and create a new data source using the ODBC type. Select the DSN you created, provide the same SQL credentials, test the connection, and save it.

5. If you're using Cognos Framework Manager, open your existing model, go to the data source, and replace the old SQL Server source with the new Fabric ODBC source. Re-import metadata if the schema has changed, validate, and republish the package.

6. Open your Cognos reports or dashboards and test them using the updated package. Verify data loads correctly and performance is acceptable.

7. Make sure your Fabric access is limited to the necessary read roles, verify that port 1433 is open for outbound traffic, and use materialized tables in Fabric for better performance if needed.

Reference links : https://learn.microsoft.com/en-us/fabric/data-warehouse/connectivity 

If the above information helps you, please give us a Kudos and marked the Accept as a solution.
Best Regards,
Community Support Team _ C Srikanth.