Blog

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

By Ryan Howe

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.

Tags: 

Ryan Howe

Partner, Clients First Business Solutions New Jersey

Ryan Howe is a Certified Public Accountant turned SAP Business One consultant. Leading the SAP Business One practice at Clients First, Ryan has over 23 years’ experience in the financial management and ERP industry, specializing in business analysis, relationship building, and business process optimization. When he’s not helping customers leverage SAP Business One to meet their short and long-term needs, you can find him at any Michigan State sporting event with his family – go Spartans!