Web Store and Point of Sale (POS) Integration Techniques

Note: this discussion assumes you are familiar with the concept of ETL. Note: this demonstration uses this Business Partner Import process. Note: Here are the links for the sample file and Import Loader Formats used below. Use GardenWorld's Pack In window to load the Import Loader Format records.

Introduction
0:01:00 External order sources
0:02:15 Agenda for next four days
0:03:00 What the external order management system is telling your ERP (what needs to be imported)
0:05:30 What the ERP is telling your Web Store or POS
0:06:30 The Export/Import structure and diagram - using files or ETL
0:09:30 Question by Gerald - can an iDempiere process to read directly from an external database?
0:12:30 Question by Dave - use ETL to move data (pricing) to a remote web store?
0:18:30 Comment by Kevin - data from a web store can be more complex than what can be held by a single staging table.
0:19:15 Question by Jaures - what about messaging like JMS, RabbitMQ, etc... How compare to ETL.
0:21:30 Question by Jaures - Can you create your own iDempiere i_ import table?
0:23:45 Migrating data between your Web Store/POS and your ERP
- Web Store/POS send
- 0:27:30 ERP receive
- http://wiki.adempiere.net/Calling_a_process_from_code
0:29:45 Benefits of using batch imports
0:3245 Example of manual importing a Point of Sale (POS) order
- Review POS export
- 0:34:30 Import Business Partner (BP)
- 0:39:00 Import Order
- 0:42:45 Import Payment
- 0:43:45 Run Auto Allocation process
- 0:44:45 Automating the above processes
0:46:15 Using the correct Sales Order Document Type
0:52:00 Next week - use web services instead of ETL
0:53:30 using adapters - like OpenERP's adapter for Magento (or visa versa)
1:00:00 preparing for next week's web services discussion (link)

Be aware that I did not accomplish my goal before this meeting. I had intended to execute a webservice to run a process from Talend ETL.
Three options to migrate data
- iDempiere code - Web Store /POS push to iDempiere staging tables + use iDempiere processes to move through i_bp, i_order, i_payment, etc.. tables all the way through the final destinations.
- Web Services - Web Store / POS to use web services directly to BP, Order and Payment tables (bypassing the staging tables)
- ELT - to pull from Web Store /POS and push to iDempiere staging tables. ETL to use web services to execute iDempiere processes.
Discussion of pros and cons of ETL vs web services.
0:11:15 How to ensure you get all orders (no duplicates) from the web store or POS despite heavy order loads.
0:14:30 How to confirm the ERP received the order batch details.
0:22:30 iDempiere web services overview - major components
- Talend ETL - automation tool
- SoapUI - web services play/test tool
- iDempiere - web services
- 0:25:30 iDempiere - how to find WSDL
0:26:45 Creating your first SoupUI project to run your first web services call
0:03:00 Using the same SOAP message inside talend ETL (here is where I failed :)
0:32:00 Introduction to iDempiere Composite Web Services.
0:35:00 Errors in Talend that prevented my web services success.