In Cognos server machine have a access to connect Database server Mysql so i have created ODBC and test connection also is working fine. She can be contacted at rrwang cn. I am getting the same error when I run the report in Cognos Interestingly enough, Cognos Insight can use bit drivers probably due to it inheriting more from TM1 than Cognos proper. Create a new Cognos Datasource Open a web browser and log in as an admininstrator to Cognos. Open asynchronously Select if you want the connection to process requests independent of each other. You specify connection parameters when you create a data source or modify a data source connection.
|Date Added:||9 July 2009|
|File Size:||19.97 Mb|
|Operating Systems:||Windows NT/2000/XP/2003/2003/7/8/10 MacOS 10/X|
|Price:||Free* [*Free Regsitration Required]|
For example on Linux, add the following to “daily-refresh. Please help me to resolve this issue. If the credentials to the database match the credentials used to logon to the IBM Cognos environment, for single signon, select An external namespace and select the appropriate namespace.
Jan 25,2: ODBC connect string Enter any text that must be appended to the connection string. For more information about the ODBC. ReportServerHandler Do you have any idea about it. Configuring IBM Connections cofnos.
How to connect Cognos 10.2 use ODBC?
Select the Project at the top of the tree view on the left side of the window. Once downloaded, a simple double click of the msi should start the installation wizard the zip version is probably different, it should have instructions included. IBM Cognos Administration menu option 3.
The Data Source Connections should be automatically selected. Go to the “demo” subdirectory in the DataDirect installation directory, and run the command: Add the environment variabls for scheduled cube generation tasks: Set the appropriate library path environment variable to specify the location of the ODBC libraries for your operating system:.
Enter any text that must be appended to the connection string.
Click Update metrics; Metrics should be able to complete updating successfully and the reports display without error. For AIX or Linux: Specify the time in seconds within which you want the database to connect or wait for your reply before timing out. Try recreating the connection on that tab, but make sure there are no other connections with the same name, otherwise it will cause them to fail. From the list, select the MySQL 3. Jan 23,1: Add the variable to JVM environment variable list:.
MySQL is quite possibly the most commonly used database today due to its free license tier making it a very low risk investment. To have the database have wait indefinitely, enter zero, which is the default. Copy and paste this wiki markup to link to this article from another article in this wiki. Recent articles by this author.
This parameter is typically left blank. Leave everything else as it is and hit Next. Collation sequence Enter the collation sequence to be included in the database connection string. Try republishing the package from framework manager. Press Odc and the connection should now be visible in the list: Interestingly enough, Cognos Insight can use bit drivers probably due to it inheriting more from TM1 than Cognos proper.
IBM How to use Excel as a data source in Framework Manager. – United States
Beyond that, the easiest option might be to just recreate the reports in the new system. Click OK, to save configuration change. Press the OK button and it should now show up in the list.