NAPERVILLE, IL, October 10, 2008
/24-7PressRelease/ -- If you have implemented SAP B1 and now have phase two integration with legacy system or external CRM application needs, then you should first research SAP Business One Data Transfer Workbench and its ODBC integration options. This publication should ideally help you with your SAP Business One consultant, VAR or technology partner selection. If you need advanced integrating application with custom screens, you should consider developing in C# or VB.Net with SAP Business One SDK gateway to your SB1 server. Let's come to technology highlights:
1. SB1 Workbench. You probably heard from SAP Business One consultants the convenient way to move your legacy ERP application objects to SAP Business One. All you need to do is to fill our Excel CSV templates and they will be integrated via Workbench. However this is not the whole story - in fact, Workbench could serve you as ongoing integration tool, where you schedule integrations in DOS Batch file by calling Workbench with the parameter of saved integration setup CML file
2. SQL Views. If you want to prepare your records for integration automatically, consider switching from Excel CSV templates to ODBC integration in Workbench, where ODBC connects to SQL complain database with prepared SQL view - it could be Oracle, MS SQL Server, Pervasive SQL, Microsoft Access to give you flexibility idea
3. SB1 tables structure. In SDK you can research the structure, however when you need to prepare your Workbench integration, the best idea is to look up relevant tables and their contents in SB1 MS SQL Server company database. In SB1 View-_System Information - this will give you table, form and field info in left lower corner. Try this - open Inventory-_Item Master Data and place the cursor over the field to the right of the Item Number - you should see the table name is OITM and the field name is ItemCode. Please continue your discovery, if you need help, let us know
About Alba Spectrum Group
Andrew Karasev, Alba Spectrum LLC, help@albaspectrum.com, http://www.albaspectrum.com, 1-866-528-0577 , subdivision of M2-D2, SAP Business One VAR and Reseller in Illinois, Georgia, South Carolina, California, Texas. Please visit our info portal Pegas Planet: http://www.pegasplanet.com. Local Service in Chicago, Atlanta, San Diego, Los Angeles, Orange County, Houston. We also have SAP Business One Software Development Factory and SB1 Technical Support Call Center, serving USA country side businesses and internationally: Canada, Brazil. Illinois practice: Naperville, Aurora, Plainfield, Marseilles, Ottawa, DeKalb, Springfield, Oakbrook, Glenn Ellyn, Wheaton, Bolingbrook, Romeoville, Lisle, Melrose Park, Brookfield. San Diego and LA practice: Rancho Bernardo, Oceanside, Poway, Long Beach, Irvine, Mission Viejo, San Marcos, Carlsbad, La Jolla, Escondido. Houston Practice: Dallas, Galveston, Sugar Land, Pearland, Katy, Pasadena, Rosenberg, League City, Galena Park
# # #
Read more Press Releases from Andrew Karasev:Other Press Release Headlines:- ACCLAIMED NEW BOOK OFFERS 'JUST ENOUGH GOVERNANCE' FOR LOTUS NOTES
- New York Kids Club Founder, Pam Wolf, Wins Stevie Award
- New York Kids Club Founder, Pam Wolf, Has Been Selected to Serve as an Expert Contributor to ABC's Hit Television Show, Super Nanny!
- Transformation Systems, Inc. Celebrates 5 Years in Richmond & Upcoming Book by Founder, Marta C. Wilson, PhD
- www.AffinityProperties.com Expands Portfolio of Home Builder Profiles
- Bangkok Hospital Patients Receive Same Service As the King of Thailand
- Developing Regions Driving Global C-Store Industry, Asia-Pacific to Hold Sway
- IT VARS Fly-In To Become Certified To Sell Minicom'S Centralized Remote Access & Management Solution
- Outdated Email Lists Can Damage Your Business, Says Business Expert
- BnBStar.com presents new featured Bed and Breakfast inns in Delaware, Oregon, Nevada, Oklahoma, Washington and other locations across the US
