SAP Business One Data Transfer Workbench can load data from ODBC as source data. Prerequisites You have prepared the source data in a legacy database. You have created a data source name (DSN). To configure the Data Source, proceed as follows: Choose Start Control Panel Administrative Tools Data Sources (ODBC) Choose the User DSN tab or the System DSN tab. Choose the Add button. The Create New Data Source window appears. Choose SQL Server and click the Finish button. The Create a New Data Source to SQL Server window appears. Specify Name, Description and Server, and choose Next. Set authenticity, the default database to your database, and choose Finish. Procedure Logon Companies You have a database Local, and the data source name (DSN) is defined as Local. If you want to load BusinessPartners from the MyOCRD table, and BPAddress from the MyCRD1 table, proceed as follows: In ste...