Sap Business Objects Data Integrator
sap business objects data integrator
SAP Business One Integration and Data Conversion Notes
We will try to base our notes on SB1 2007A version, which is the one for USA, however international SAP B1 users are welcome to read this article. We will only review out-of-the-box integration solutions: Data Transfer Workbench, if you would like to familiarize yourself with SAP BO ISV partner add-ons or integration platform, please look at eBolt and other SAP Business One resellers, it is outside of the scope here. SB1 ERP, MRP, CRM, Financials, Service, HR, Sales and Purchasing modules are exposed to programmer via SB1 Software Development Kit, however with SDK SAP requires work to be done by certified SDK partner, plus you should talk to your SB1 Reseller on purchasing SDK license if you plan to do extensive SDK customizations. We expect that your issue is rather data conversion and ongoing integration from EDI source, ecommerce application, etc., in this case let’s first review the power of Data Transfer Workbench, and only after, if you feel that this is not enough we will move to SDK:
1. SAP Business One Data Transfer Workbench. If you are SBO certified consultant, you should remember your exercises in initial data import: business partners, GL accounts, Inventory Items, Price Lists, Initial Item Quantities, GL Initial Balances. In all these examples you were given CSV templates, which should be filled in with required and optional fields, then when you come through Data Import Wizard, you provide connection to your CSV filled in templates. However, if you are also familiar with such concepts as ODBC Connection, MS SQL View, please consider SQL views creation, which will resemble exactly the same pattern as filled CSV files. Let’s assume that you are placing purchase orders via your EDI partner channel, select oPurchaseOrder business object, then highlight Document and switch Source Data Type to ODBC, click Browse and in Simple Select Statement use your SQL knowledge to select data from the view created above – PO header should be taken care about. Now required element is Document_Lines – here follow the same approach, plus take care if additional objects are needed in your case. Now, the trick – if you followed exact Column Names in the SQL View, then columns mapping will be also recognized automatically in the Wizard. Then, assuming that you are familiar with CSV data conversion way in SB1 – you will get work done. Here we have to admit to our displeasure, that for 2007A SAP recognized that ODBC integration scheduling is not supported, and as we figured out it doesn’t work. But, even so, in our opinion five minutes of SB1 Data Transfer Workbench of operator time will allow you to import your desired objects and it worth the time spent. Please, at this point review objects exposed via CSV templates, and give us a call if something is not covered that you need to be covered. So, maybe next step – SAP Business One SDK certification and programming is optional for you?
2. SAP B1 SDK. Here please consider the option to find really good SB1 ISV and Technology partner with Software Development Factory. SDK has access to virtually all SB1 objects and you can do real time data integration from your legacy ecommerce application, change user interface
3. Direct SQL data feeding. Please avoid this, as SAP Business One has Early Watch service, which is tracing SQL DB data intervention, instead revisit Workbench or SDK Programming options
4. Extra SAP Business One Modification Tips. You can extend existing tables by adding User Defined fields, and these fields automatically will be assigned data entering interface. If you add custom fields to your Business Partner, for example, simply pull BP records and in menu click View -> User Defined Fields. If you have to create new User Defined Table, it also gets data entry interface automatically
5. We are restricted by Article genre, so, please if you would like to hear your business case study, or SAP Business One Executive or Technical presentation, please feel free to call us: 1-866-528-0577, help@albaspectrum.com
About the Author
Andrew Karasev, Alba Spectrum, subdivision of M2-D2, help@albaspectrum.com 1-866-528-0577 http://www.albaspectrum.com Serving ERP and MRP community since 1994, local service in Chicago, Houston, San Diego, Atlanta. Information portal: http://www.pegasplanet.com We serve you USA and Canada nationwide from our SAP Business One call center: California, Illinois, New York, Florida, Minnesota, New Jersey, North and South Carolina, Georgia, Louisiana, Texas, Ontario, Quebec, Washington, Missouri, Iowa, Nebraska, Kansas, Colorado, Nevada, New Mexico, Utah, Arizona, Montana, Oregon, New York, New England. International clients welcome from Australia, New Zealand, Oceania, South Africa, UK, Brazil, Caribbean, Russia, Central America
|
|
BusinessObjects XI (Release 2): The Complete Reference $34.99 This book is a must read for anyone deploying BusinessObjects. It covers everything from planning your upgrade to the latest release, to best practices in universe design, and powerful report creation that maximizes business insight. This book covers the most frequently used features for the full BI suite, in one comprehensive book. There’s in depth coverage of Designer, security via the Central M… |
|
|
Sap Business Objects Interview Questions : Business Objects Certification Review $29.11 No Synopsis Available |
|
|
Business Objects Crystal Dashboard Design 2008 Personal Edition $810.99 1 Named User 7090268 Advanced dashboard and visualization components Live data connectivity to an external data source via a SOAP-based Web service or an XML data feed Enhanced SAP Crystal Reports integration Export to Adobe Flash, AIR and HTML Software Development Kit And, more! Processor: 1.0 GHz Operating System: Microsoft Windows XP Microsoft Server 2003 Microsoft Vista Hard Disk: 350 MB space Memory: 1GB RAM (recommended) Others: Microsoft Office 2003 Microsoft Office XP Microsoft Office 2007 Create Engaging and Interactive Dashboards SAP Crystal Dashboard Design, personal edition is the perfect way to get started in the exciting area of dashboarding. It lets you create business dashboards and data presentations from spreadsheets, corporate databases – and share them “live” via SAP Crystal Reports, Microsoft Office, Adobe PDF, AIR and the Web.. Business Objects Business Objects SA Business Planning CD-ROM Complete Product Crystal Dashboard Design 2008 Personal Edition E-Business Not Applicable PC Retail Software Standard Windows www.businessobjects.com |
|
|
Business Objects Crystal Reports XI Developer Edition $547.99 1 Named User 7090241 Processor: Pentium II Operating System: Windows 2000 with Service Pack 4 Windows XP Hard Disk: 350MB Memory: 128MB RAM A world standard for enterprise reporting, Crystal Reports from Business Objects, an SAP company, is an intuitive reporting solution that helps you rapidly create flexible, feature-rich, high-fidelity reports and tightly integrate them into your web and windows applications. Business Objects Business Objects SA CD-ROM Complete Product Crystal Reports XI Developer Edition Crystal Reports v.XI Developer Edition Database Database Reporting Not Applicable PC Retail Software Standard Windows www.businessobjects.com |
|
|
Learning SAP Crystal Reports 2011 $79.95 In this training course for SAP Crystal Reports 2011, veteran trainer Guy Vaccaro teaches you how to use this powerful enterprise-level business intelligence software. You will learn how to connect to your data sources, design reports, and distribute your reports as required. |
|
|
SAP Crystal Reports 2008 $450.99 1 Named User 7090243 Powerful report designer: Report authors benefit from a complete set of layout and design controls to create highly formatted, interactive, and professional-looking reports. Flexible application development: Developers can easily leverage the full support for .NET. Crystal Reports generates HTML directly, allowing developers to focus on application business logic rather than tedious, time-intensive hand coding. Report management and delivery: Reports are previewed in HTML and published to the Web for easy and controlled sharing allowing for better business decisions at all levels of the organization. Processor: Intel Pentium III or equivalent Operating System: Windows Vista (All Editions) Windows XP Professional with Service Pack 2 Windows Server 2003 Datacenter Edition with Service Pack 1 Windows Server 2003 Enterprise Edition with Service Pack 1 Windows Server 2003 Standard Edition with Service Pack 1 Windows Server 2003 Web Edition with Service Pack 1 Windows Server 2003 R2 Datacenter Edition Windows Server 2003 R2 Enterprise Edition Windows Server 2003 R2 Standard Edition Windows Server 2003 Datacenter Edition with Service Pack 2 Windows Server 2003 Enterprise Edition with Service Pack 2 Windows Server 2003 Standard Edition with Service Pack 2 Windows Server 2003 Web Edition with Service Pack 2 Hard Disk: 300 MB 600 MB Recommended with Visual Studio .NET integration Memory: 256 MB RAM 512 MB Recommended Optical Drive: CD-ROM (for CD install only) Others: Screen resolution of 1024 x 768 is Recommended Crystal Reports from Business Objects, an SAP company, is an intuitive reporting solution that helps you create flexible, feature-rich, and dependable reports tightly integrating them into both thick-client and thin-client applications. CD-ROM Complete Product Crystal Reports 2008 Database Database Reporting PC Retail SAP SAP America, Inc Software Standard Windows www.sap.com |
|
|
Business Objects Crystal Reports 2008 $459.99 1 Named User 7090243 Empower end users to explore reports interactively: Xcelsius Integration Adobe Flex Integration Parameter Panel Interactive Report Viewing Create compelling reports with stunning visualizations: Flash Integration Powerful Crosstabs Flexible Pagination Develop Powerful Data Mashups: Xcelsius, Adobe Flex, and Adobe Flash Integration Enhanced Web Services Data Driver Save Valuable Report Design Time: Built-in Barcode Support Enhanced Designer Features Single Edition Multilingual Reporting Reduced Install Footprint Hyperlinking Wizard Enjoy Comprehensive Report Deployment Options: Save reports directly to crystalreports.com Integrated SalesForce.com Driver Improved XML Exporting NET Report Modification SDK Advanced Report Publishing Processor: Intel Pentium III or equivalent Operating System: Windows XP with Service Pack 2 Windows Server 2003 with Service Pack 1, or later Hard Disk: 300MB available space (600MB recommended with Visual Studio .NET integration) Memory: 256MB RAM (512MB RAM recommended) Others: Visual Studio 2008, 2005 and 2003 Crystal Reports 2008 is a powerful, dynamic, actionable reporting solution that helps you design, explore, visualize, and deliver reports via the web or embedded in enterprise applications. It enables end users to consume reports with stunning visualizations, conduct on-report business modeling, and execute decisions instantly from the report itself-reducing dependency on IT and developers. Business Objects Business Objects SA CD-ROM Complete Product Crystal Reports 2008 Database Database Reporting Not Applicable PC Retail Software Standard Windows www.businessobjects.com |
|
|
SAP Crystal Reports XI Developer Edition $547.99 1 Named User 7090241 Processor: Pentium II Operating System: Windows XP Windows 2000 with Service Pack 4 Hard Disk: 350 MB Memory: 128 MB RAM Crystal Reports from Business Objects, an SAP company, is an intuitive reporting solution that helps you rapidly create flexible, feature-rich, high-fidelity reports and tightly integrate them into your web and windows applications. Box CD-ROM Complete Product Crystal Reports XI Developer Edition Crystal Reports v.XI Developer Edition Database Database Reporting Not Applicable PC Retail SAP SAP America, Inc Software Standard Windows www.sap.com |
|
|
The CFO as Business Integrator $61.15 No Synopsis Available |
|
|
The Cfo As Business Integrator $48.75 This book is in New – Excellent condition |
|
|
Business Objects Crystal Reports v.10.0 Developer Edition $547.99 1 Named User 7090239 Processor: Pentium II Operating System: Windows 2000 with Service Pack 4 Windows XP Hard Disk: 350MB Memory: 128MB RAM Designed for easily integrating report viewing, printing and exporting capabilities into applications, Crystal Reports 10 Developer Edition provides both report design and developer tools for integrating reporting into applications. It includes the complete Crystal Reports feature set and a development license of Crystal Enterprise Professional Edition for delivering information and centralizing data access and report management. Please note that the trial offer of Crystal Enterprise Embedded Edition for offloaded report processing and runtime report creation is not included any more. Business Objects Business Objects SA Complete Product Crystal Reports v.10.0 Developer Edition Database Database Reporting Not Applicable PC Retail Software Standard Windows www.businessobjects.com |
|
|
Business Objects Crystal Reports XI Professional Edition $459.99 1 Named User 7090242 Powerful Data Access and Report Design: Business Views BusinessObjects Universes Updated Drivers Dynamic Image Location Updated Visual Report Designer Intelligent Charting Hierarchical Grouping Enhanced Productivity and Maintenance: Dynamic and Cascading Prompts HTML Preview Editable RTF Format Report Export Configuration Repository Explorer Workbench Dependency Checker Flexible Application Integration: Free Runtime Licensing New and improved APIs Custom Java function Libraries Data Binding Crystal Reports Server – Report Management and Delivery: Security Scheduling Scalable Central Architecture Processor: Pentium II or higher (Pentium III-class recommended) Operating System: Microsoft Windows 2000 with Service Pack 4, XP, or later Hard Disk: 350MB of free space (600 MB recommended) Memory: 128MB of RAM (256MB recommended) A world standard for enterprise reporting, Crystal Reports is an intuitive reporting solution that helps customers rapidly create flexible, feature-rich, high-fidelity reports and tightly integrate them into web and windows applications. Business Objects Business Objects SA Complete Product Crystal Reports XI Professional Edition Crystal Reports v.XI Professional Edition Database Database Reporting Not Applicable PC Retail Software Standard Windows www.businessobjects.com |
|
|
Business Objects $34.32 This book is in New – Excellent condition |
|
|
Objects for Business $37.05 No Synopsis Available |
|
|
Business Objects Crystal Reports v.10.0 $459.99 1 Named User 7090240 Business Objects Business Objects SA Crystal Reports v.10.0 License PC Software Licensing www.businessobjects.com |
|
|
ABAP Objects: Introduction to Programming SAP Applications, by Keller $68.62 This book is in New – Excellent condition |
|
|
Sap Business One $72 This book is in Used condition |
|
|
Sap Business One Implementation $48.74 No Synopsis Available |
|
|
Sap Small Business One $103.35 No Synopsis Available |
|
|
Java Data Objects, by Roos $18.1 This book is in Used condition |
