![]() ![]() ![]() You will also need to open the 32-bit ODBC Data Source Administrator. If you are running Cognos from a 64-bit machine and want to modify the DSN or create other Snowflake DSNs, you must use a system DSN. This will limit the number of rows returned, which is especially helpful for improving performance when designing reports and visualizations. When you configure the DSN, you may also want to set the Max Rows connection property. See the Getting Started guide in the CData driver documentation for more information. (Optional) Set Database and Schema to restrict the tables and views exposed.(Optional) Set Account to your Snowflake account if your URL does not conform to the format above.Set Warehouse to the Snowflake warehouse.Set URL to the URL of the Snowflake instance (i.e.: ).Set User and Password to your Snowflake credentials and set the AuthScheme property to PASSWORD or OKTA. ![]() You can use the Microsoft ODBC Data Source Administrator to create and configure ODBC DSNs. This is the last step of the driver installation. If you have not already, first specify connection properties in an ODBC DSN (data source name). This article describes both a graphical approach to create data visualizations, with no SQL required, as well as how to execute any SQL query supported by Snowflake. You can use the CData ODBC driver for Snowflake to integrate Snowflake data with the drag-and-drop style of Cognos Report Studio. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
December 2022
Categories |