Assistance needed - Urgent ( Connect MSSQL2008 with Cognos)

[vivek_cyno]

Hi Techies,

Please guide me how to connect the MSSQL 2008 to Cognos.
I would need to create a database connection to remote SQL server and then to create a package.Please help me.

Thanks,
Cyno

[MFGF]

Hi,

To create your data source, you need to log into Cognos Connection as an Administrative user, go to Launch > IBM Cognos Administration, go to the Configuration tab, and add a new data source connection that points to your SQL server instance on the remote machine.

Once you have your connection configured and it tests successfully, launch Framework Manager, create a new project, and import the desired metadata from your SQL Server connection, then model it and publish a package. I assume you know how to model in FM? If not, it's such a huge topic with such enormous pitfalls to look out for that your best bet is to invest in a class and learn how to do it effectively.

Regards,

MF.

[vivek_cyno]

Hi MFGF ,

Thanks for your reply,

Can you please let me know the usage of the below,


Type:    Which one to choose,

ODBC connect string:
Collation sequence:

and then  Signon   

Could you please help me assisting with this information.Thanks a lot.

[MFGF]

Hi,

The Type setting depends upon how you plan to connect to SQL Server (ie which SQL Server client libraries are installed on your Cognos server) and which version of SQL Server you are connecting to. Since you have SQL Server 2008, you would either select Microsoft SQL Server (SQL 2008 Native Client) or you would select Microsoft SQL Server (ODBC). I would suggest the former is the most efficient and easy.

Assuming you select the first method and have the correct SQL Server client on your Cognos server, you will need to enter the hostname of the SQL Server host, the database name to connect to, you will need to check the 'Password' checkbox, then you will need to enter a valid SQL Server user ID and Password to act as the database signon.

Regards,

MF.

[vivek_cyno]

Thanks for your reply MFGF,

SQL server is not installed in local cognos server,it is installed in other server.

Now,what I have is server IP,NAME,database name,user credentials,

I need to create a new data source using all the above details. Please guide me.

Thanks

[MFGF]

Hi,

You don't need the SQL Server database installed on your Cognos server, but you do need the client libraries. If you don't have these installed, you cannot connect to SQL Server on the remote machine.

Regards,

MF.