Print Page - Get count of datasource and their types

Title: Get count of datasource and their types
Post by: kulkarni on 15 Sep 2009 02:07:14 PM

Am working on application using sdk program that fetches count of datasources on a server and the count of different types of datasources like - ODBC, MS Sql Server, Oracle, DB2, Poewrplay Cube etc

I am able to get the datasource count but not able to figure how to get types of datasource. Not sure what propenum I need to be using to get this.

Any one knows how to fetch this information (datasource type)? Thank you.

Title: Re: Get count of datasource and their types
Post by: lindero on 23 Sep 2009 04:26:17 AM

hi,

first of all you need the datasource connection object. The datascource does not know which kind of datasource type it is. Maybe this helps.

regards

Title: Re: Get count of datasource and their types
Post by: kulkarni on 23 Sep 2009 08:01:00 AM

I am using this in my searchpath - //dataSource/*

This fetches all the datasource connection under all the datasources. I am able to get the connection string. Please see the attachment. It is from my debugging mode in .Net

There are 2 distinct screenshots in the attachment. Each of them show various property associated with the datasource Connection. None of them tells us the datasource type!

Thanks.

Title: Re: Get count of datasource and their types
Post by: kulkarni on 23 Sep 2009 08:11:11 AM

I am unable to attach the jpeg file!

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => SDK => Topic started by: kulkarni on 15 Sep 2009 02:07:14 PM