source dedicated server config
SAP Business One Var Newsflash: Workbench Integration Highlights
SAP B1 is dedicated to small and medium enterprises. This ERP and MRP enriched accounting application becomes more and more popular, especially since the release of SB1 version 2007a. The intuitive and simple SAP BO interface often comes with the fact that SAP Business One is delivered without certified Consultant solid technical background in data conversion, customization, SDK programming and also in making ad-hoc SQL queries. In this small publication we give you technical highlights advanced integration technologies with SAP Business One Data Transfer Workbench. This publication should help you with your SAP B1 partner, VAR, implementation consultant, reseller and ISV technology partner selection. We should mention that you can always go and deploy SAP Business One SDK programming in integration creation, but here we will focus on "low profile ". Let's start: 1. SB1 Data Transfer Workbench: CSV file and Excel templates. Through our practice, many of SAP Business One functional consultants recommends easy to follow template Excel files filling and saving them in CSV format as preferred way to integration. Plus, they also recommend it for one-time integration only in the original data conversion and migration. If you do not need additional discovery and looking for second opinion in SAP Business One partners community – this advice is good and very reliable. But – what to do if you ongoing and even scheduled integration? 2. Simple ODBC queries. Let us step aside and try to ODBC Data Source Type. If you are IT professional, SQL DBA or programmer, you know, that ODBC connection opens the whole new world of such nice tools as MS SQL Server linked server, SQL View to break through the limitations of text files 3. SQL Views Scenario. Now, imagine instead of depending on CSV files created by hand, create SQL view, which will be the basis for integration. If you integrate SB1 with front-end legacy database (including SQL Server associated structures such as platforms, including Oracle, DBII, Ctree, Pervasive SQL), you must find required SQL view structure in Excel templates for the intended SB1 objects and simply Microsoft SQL Server to Level 4. Scheduling Workbench ongoing integration. Workbench allows you to help integrate the structure into XML-format store (you do it on the Step 5: Enter the details import – click Save button and you will be able to integrate into the XML schema to store). Create-bat (DOS batch file). Then schedule in Start-> All Programs-> Accessories-> System Tools-> Scheduled Tasks. This line would sample BAT file: C: Program Files SAP Data Transfer Workbench DTW-s C: Program Files SAP Data Transfer Workbench config.xml