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?