On completion of this training exercise we will;
- Use the Web Service Connector tool to connect to the bigcommerce API
- Get the order headers and details
- Map, transform and convert the data
- Write the order headers and details to the staging database
Prerequisites
- Staging Database, with appropriate drivers installed
- Mapping and Data Transform files
- Deployment of BigCommerce
- These assets can be downloaded from: http://trainingresources.codelessplatforms.com
Required Tools:
- Web Service Connector
- Convert XML to Recordset
- Run VB Script
- Call Stored Procedure
- Transform Data