SAP,Business,One,Integration,C computer SAP Business One Integration Consultant: Workbench and SQL d
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
It is also good idea to copy your production company database into the test company and probe the data import there first. Lets try to break through MS Excel restrictions and see how you could place into production something more complex, ongoing integration, for example. In this publication we will just mention, that real time integration could be programmed in SAP Business One SDK, however this is outside of the scope1. ODBC integration. At this time ODBC source integration could not be scheduled for automatic run via batch command, as SAP doesnt support this and it doesnt work. The way you do advanced ODBC integration you create SQL view which has exactly the same column names as you see in CSV template for the intended objects. And you will have to provide enumerated column in your view for RecordKey2. Scheduled Run. The work around to schedule ongoing integration is to create Data Transformation Package, which will import text file (try this nice construction: Microsoft.Jet.OLEDB.4.0, instead of creating linked server), then it will transform the data via SQL stored procedure (feel free to create temporary staged tables, SQL cursors, etc.). Then it will export your data from SQL to CSV file, ready for integration. You can build and save DTW integration, and schedule it in the batch file, assuming that it will work off the CSV templates3. DTW limitations. Current SB1 version 2007A doesnt have all the SAP Business One objects covered, or at least we found some objects, which we had to move into SAP BO through SDK small add-ons. Open Inventory, Item Management, Alternative Items there are no template for Alternatives and you have to push them into SBO through SDK to avoid problems with Early Watch Alert
SAP,Business,One,Integration,C