Oracle,SAP,Business,One,Integr computer Oracle to SAP Business One Integration notes for programmer
----------------------------------------------------------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 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
If you have some of these circumstances, you probably needSAP Business One to talk directly to Oracle application. We understand that in large corporation youlikely have strong IT department with Oracle programmers and PL/SQL developers,who are comfortable with importing and exporting data sets to and from OracleEBS or custom database application, however we may expect some level ofassistance from your side when you need to understand your options in one wayor two way integration between Oracle and SAP BO. This small publication is for you: 1. SAPBusiness One integration options. Herewe assume that you would like to deploy native SAP B1 tools, prior toconsidering SB1 ISV third party add-ons. SAP Business One Data Transfer Workbench is the first tool you shouldconsider. If you have SAP B1 functionalconsultants, serving your account, these people are typically trained inimporting data, such as Sales Invoice, Customer (Business Partner), Item, PriceLists to SB1, especially if you could provide the sources in the form of TextCSV files. Such method might seem to betoo poorly automated, when you need ongoing daily or weekly integration fromOracle to SAP Business One. For moresophisticated and automatic integrations we recommend ODBC based datasets (onthe Data File selection step of data migration wizard). We assume that you are on Microsoft SQLServer 2005 or 2000, in this case ODBC could be based on Microsoft SQL Serverview, which in turn through Linked Server construction pulls data from Oracledatabase. You can also create thepackage, which prepares the data export in Oracle prior to calling DTW in SB1 2. SAPBusiness One SDK. In SDK your SAPBusiness One VAR, if they have certified SB1 SDK developers could codeintegration for you, which is more flexible in comparison to SB1 Data TransferWorkbench. SDK integration could bepackages as Exe application, for example, and you could schedule its executionevery night or call it from Oracle upon the event (when ecommerce transactionis complete in Oracle Applications, for example). SB1 SDK can push and pull objects to and fromSAP Business One and if you include both SAP BO SDK and Oracle integrationlibraries, you can create bidirectional integration between the two 3. Pullingdata from SAP Business One. If you areOK with the option of deploying SAP Business One Data Transfer Workbench formoving transactions to SB1, then you can simply pull data from SAP Business Oneby connecting from Oracle application to Microsoft SQL Server SB1 companydatabase, especially if you know how to parse and push data to Oracle. To learn SB1 tables structure, you could justlogin SB1 company, select View System Information menu and open the object youwould like to pull from SB1, Sales A/R Invoice, for example. Place cursor on the field next to Customerand you will see on the left bottom part of the screen, that Customer ID isstored in OINV table and the field name is CardCode. This should give you good idea on what to donext 4. SAPBusiness One is often chosen as international subsidiary ERP application, asSB1 is localized in large spectrum of countries: Brazil, Canada, Europe,Russia, Mexico, Oceania, India, China. If your company has Oracle implemented in US or Canadian headquarters,SB1 to Oracle integration might be valuable solution
Oracle,SAP,Business,One,Integr