Hi,
I work on SQL Server 2012 Business Intelligence tools SSAS Multidim, SSAS Tabular, SSRS, SSIS, PowerPivot...etc.
In our current organization, we are using mostly PowerPivot and SSAS Tabular. we use Oracle Exadata as a data source. If you want to connect to data source, you will set up a connection in your solution file in SQL Server Data Tools. The Developer has to enter the ID and password for oracle database.
As our organization is tightening the security, we would like to maintain a config file instead of each individual to create a connection in their solutions.
In .net applciations, we set up a .config file with database connections and refer that to connect to code. Is there any similar way in MSBI tools too?
In Business Objects, there is a connection manager where admin set up the connections at once and provide read access to developers. I am looking for similar kind of functionality here in MSBI. Is this possible or not?
Thank you
Venkat.