Adhoc Query Tools for Navision Implementation Using SQL

jaguilar

Hi all,

Does anyone know of a Adhoc Query Tool that allows users to query a Navision SQL Server database?

The issue is to prevent users from logging into the database login with their windows authentication id.

The preferred method would be only to allow them to log in with a database server id.

Most adhoc query tools are meant for developers and not end users which allow logging into the database through both database id or windows authentication.

Does anyone know of a tool that only allows users to log in with a database server id?

Thanks.

bbrown

If you don't wnat users accessing Navision with windows authentication, then don't grant their windows accounts access right to the database.

Regardless of the login options the query tool gives the user, they can only use the ones granted to them.

Granting end users direct adhoc query access to a production accountign system is a very bad idea.

DenSter

Yeah just remove access to the database from the user ID.

ml1

Normally Standard ReportingComponents using their own Security layer.
This Layer takes a predefined database user-Account for the connection. The connection could be applied with a lower Isolation-Level(Dirty-Read). This prevents the ReportingComponent for creating or running into a DeadLock.

Standard Tools would be:
BusinessObjects
Cogons
MS-ReportingServices
MicroStrategy

But it is always better to build a own ReportingDatabase(DataMart) for reporting needs. Than nobody has a problem on the production system.

Regards
Martin

mr.mcgoo

You could use the Report Builder in Reporting Services. This needs SQL 2005 but your Navision data doesn't have to be on 2005.

You still need to do some work by creating data templates, which are in effect SQL Views. Report Builder is an end user tool for ad hoc reporting. You can set the security and whatever level you want for groups or individual users.

The pros of this are that if you have at least a standard SQL2005 server all ready, Reporting Services and Report Builder come free.

The cons are that you have to effectively set up a layer of views for the end users to protect them from themselves!