Using ODBC with SAP Business One via the Data Transfer Workbench (DTW)

If you’ve ever wanted to import data into Business One (B1) directly from another data source such as SQL Server, Access or some other data source that supports ODBC (Open Database Connectivity) there is a new article on how to do this as the SAP Community Network.

This makes certain data transfer situations easier as you don’t have to find and use some type of export tool to get the data into a delimited format.  You can also use a more complex SQL query to pull tables together server side and import them into DTW.

Unfortunately, DTW does NOT dsupport scheduled imports via ODBC so it’s not a good solution for some type of integration. You would be better off using a solution like xFusion.

Click HERE for the full article.