Skip to Content
0
Mar 20, 2009 at 02:38 PM

Connect BI with DB MSSQL as Data Source

16 Views

Hi Experts,

I got an issue trying to extract data from BI to a Business One DB (mssql 2005).

1) I´ve created the data source connection and check was successful.

2) I´ve create a special database user for the extraction called biconnect in MSSQL with the db_ddladmin database role in the corresponding database.

3) I Assign the necessary authorizations (SELECT at least) to the

selected user in the source tables, or the columns of these tables.

4) Use the specially created login in the logon information when you

set up the DB source system in BW.

What else can i do?