![]() ![]() ERP, and CRM data in MS SQL Server, and NetSuites saved searches feature. You can refer to the () section of the () to get more details. This guide assumes the above and you also have MSSQL and Access Database. The Access ODBC driver must be installed on each QuerySurge Agent box, because the Agent uses a JDBC-ODBC bridge to connect to the files through this driver. Alternatively, I can choose **Direct** option on **Connection Type**, provide the mdb or accdb **File path** and choose “MS Access Driver” on the **Driver** drop down. On **Connection Type**, I would choose **DSN** option and select the DSN created in Step 1 on the **DSN** drop down.ġ. Choose “Access” on the **Database Adapter** list.ġ. Open **ODBC Data Source Administrator (32/64-bit)** tool, create User or System DSN for the **mdb** or **accdb** file using **MS Access Driver**.ġ. ![]() In order to connect to MS Access from Denodo, I would perform the following steps:ġ. ![]()
0 Comments
Leave a Reply. |