Print Page - MsSQL: access to table but not to data

Title: MsSQL: access to table but not to data
Post by: Subz on 09 Jul 2018 05:48:40 AM

Hi :-)

we just set up an MsSQL Data Source in the CA configuration. The test is successfull. In the Framework Manager we can import a table (we also can see all columns), but we are unable to receive Data. It fails every time. We installed the latest DB driver on the CA Server.

The DB User has the correct rights and we are receiving data with the mssql explorer.

Have someone an Idea why we cant receive Data?

Thanks :-)

Title: Re: MsSQL: access to table but not to data
Post by: fry on 09 Jul 2018 08:48:28 PM

Are you running Framework Manager as admin. If you are using drivers, make sure you are using DQM in FM

Title: Re: MsSQL: access to table but not to data
Post by: Subz on 11 Jul 2018 03:24:16 AM

yes, I´m admin at the FWM and we are using DQM with JDBC.

Its strange that we have access to the meta data of the table, but not to the data :(

Title: Re: MsSQL: access to table but not to data
Post by: sdf on 18 Jul 2018 11:10:06 AM

just for checking, can you set up an ODBC connection to your SQL and try to use that?

Title: Re: MsSQL: access to table but not to data
Post by: the6campbells on 20 Jul 2018 08:54:11 AM

JDBC (and ODBC) metadata methods can return metadata for objects (i.e tables) even if the user performing the API call does not have the ability to query the table.

In some cases, a vendor may internally filter their metadata responses to only return those the use has access to, but that is not a requirement of the specification.

COGNOiSe.com - The IBM Cognos Community

IBM Cognos Analytics Platform => Cognos Analytics => Administration and Security => Topic started by: Subz on 09 Jul 2018 05:48:40 AM