SAP,Business,One,Data,Integrat computer SAP Business One Data Integration via ODBC Queries
Gone are those times when the companies and the organisations didn't need a hi-tech system to handle them. Owing to the considerable increase in the business sector and thus, an enormous increase in the complexity of the organisational struc ----------------------------------------------------------Permission is granted for the below article to forward,reprint, distribute, use for ezine, newsletter, website,offer as free bonus or part of a product for sale as longas no changes a
Assuming that you are small or mid-size business, likelythat you would like to use free instruments, versus purchasing somethingcomparable to your SAP BO software cost (iBolt for example). In this small publication we would like toreview free SBO integrating methods: Data Transformation Workbench, SAPBusiness One SDK programming: 1. Firstof all we would like reassure you that in the integration you can go beyondsimple Microsoft Excel templates filling up and saving them in CSV format. Instead you should think about flexibility ofODBC connection for SB1 Data Transformation Workbench or even directmanipulation of SAP Business One objects in SB1 SDK or Software Development Kit 2. ODBCconnection in Data Transformation Workbench. SB1 DTW was intended for initial data conversion or ongoing data importto SAP Business One. You may also knowthat if you are using CSV files you can schedule DTW integration in Batchfile. In this scenario, if you haveexternal legacy Database: Oracle, DB2, Lotus Notes, Pervasive SQL, Ctree,Microsoft Access, or even tab delimited text file then using MS SQL ServerData Transformation Package you can reshape the export from your legacy applicationand save it into CSV templates to be imported in scheduled batch job. ODBC connection at this time is not supportedfor automatic scheduling by SB1 DTW. Instead, you can create SQL views, including cross-platform views (wheredata is pulled from non-Microsoft Database: PHP mySQL for example) and havingsimple DTW operator procedure import them on demand 3. SAPBusiness One EDI programming. If you areworking in the small company, but you are at the same time reasonablytechnical, then you dont have to purchase SB1 EDI add-ons and configurationtools. Instead you can deploy SQL DTSpackage, reading EDI text file and transforming it into CSV DTW templates oropening it to the DTW via ODBC SQL view 4. SAPBO SDK programming. SDK opens unlimitedaccess to SB1 objects and their creation, modification and deletion. SAP B1 SDK programming requires programmercertification, which might lead you to the idea to subcontract SB1 SDK softwaredevelopment project to your SAP Business One Technology Partner and Reseller
SAP,Business,One,Data,Integrat