Archive for the ‘Integration Corner’ Category

EDI Integration: Basic Requirements

Thursday, January 5th, 2012

EDI integration uses industry-specific standards and it supports multiple communication protocols. Before you start EDI Integration, it would be good if you have the following information ready:

1) EDI Standard. For example: X12, EDIFACT, etc

2) Communication Protocol: How are we going to retrieve the EDI document? Is it through FTP, local disk or AS2?

3) EDI Document version: For example: 4030. 4050, 5010, etc

4) EDI Document type: This is depending on the integration flow and the standard. Take X12 for example, 850 (Purchase Order), 856 (Shipment), 861 (Receipt), etc

WDCi Is Looking For New Recruits!

Wednesday, December 14th, 2011

WDCi is currently looking for new members to be added to the team.

Who are them looking for? They are looking for Integration Developer.

For more details about the job application, please visit here.

Want to view your MYOB Accounting inventory on your iPhone?

Wednesday, December 14th, 2011

Contact us to take a look at our new app thats currently in beta.  You’ll be able to view your inventory levels from your MYOB accounting system while on the road, using your mobile device, nifty right?

Business Catalyst Integration: eCommerce Data Model

Thursday, November 24th, 2011

As we all have known, Business Catalyst is not only used for content management, it does provide other functionalities like eCommerce, reporting and etc.

The diagram below shows the first level eCommerce data model and the relationships between each object:

Business Catalyst can be integrated via SOAP web service, however, Company info is not available in the API most likely because Business Catalyst is more contact centric.

Guess what? WDCi is going to release a Business Catalyst related integration product soon! Want to know more? Stay tuned with Tim as more information will be announced.

Bugzilla Web Service: Custom Field

Thursday, November 17th, 2011

Bugzilla front-end allows custom field to be created. So what if you want to get the custom field value over to another system? We make this possible by using the Bugzilla XML RPC web service as custom field value is retrievable.

For example, if we are integrating Bugzilla with Salesforce, we can create a custom field called “Sync to Salesforce”, it can be set to True or False. If the value is set to True, it will trigger the integration process to create/update a Salesforce Case.

Below is the screenshot of the part of Bugzilla xml response:

If you are interested in getting the Bugzilla custom values to be synced over to another system and need help on that, feel free to contact us.

SmartTurn Integration: Purchasing and Inventory Control

Wednesday, November 9th, 2011

Not long ago, we have talked how can integration helps in the SmartTurn Order Fulfillment process.  This time around, let’s us talk about another process that SmartTurn can handle, Purchasing and Inventory Control.

We can integrate SmartTurn with an ERP system, let us take an example of integrating SmartTurn and Netsuite:

1. User can create a purchase order in Netsuite for purchasing items.

2. The purchase order will then be created in SmartTurn automatically.

3. Once the user received the goods, a receipt will be created in SmartTurn and the inventory status will also be updated.

4. This will then update the status of the purchase order and a receipt will be created in Netsuite automatically.

Below is a diagram illustrates the above scenario:

Besides integrating with ERP system, SmartTurn can also be integrated with accounting system, E-Commerce system and etc. You can save time and effort by automating the inventory status update between the systems, automate purchase order creation when inventory is running low.

Upskilled saves time by integrating Salesforce and MYOB

Friday, November 4th, 2011

Got MYOB, got Salesforce?  Check out this case study for details on how Upskilled uses a pre-built integration solution to get MYOB and Salesforce talking.

Bugzilla Integration: Web Service

Thursday, November 3rd, 2011

Bugzilla is an Open Source Defect Tracking System to manage software development. We can integrate to Bugzilla through the web service or directly to the database.

For example, you can integrate Bugzilla with a support system. When a case is confirmed as a bug, then the bug will be automatically created in Bugzilla. You can find the demo here.

Interested in integrating Salesforce and Bugzilla?

Wednesday, November 2nd, 2011

Got Salesforce, got Bugzilla?  Life would be easier if they were connected right?  Checkout a quick video on integrating Salesforce and Bugzilla using the Dell Boomi platform.

SmartTurn Integration: Order Fulfillment

Thursday, October 20th, 2011

SmartTurn is a very good warehouse management system. It has features which cover from item purchasing to item shipping, within these processes, item inventory/warehouse status will be automically updated.

So how can integration help? Let’s talk about one of the features that we can perform in SmartTurn, Order Fulfillment. Here is one scenario:

1. I am managing a clothing wholesale business, a customer has ordered 200 items from my company. Within these 200 items, 100 will be shipped to location A, 50 will be shipped to location B, and the rest to location C.

2. If the customer is placing an order through my CRM or eCommerce system. The integration process can synchronise the Sales Order into SmartTurn specifying all the item details and customer’s shipping destinations.

3. SmartTurn will then check the inventory status, if the stock is insufficient, the shipment will be put ‘On Hold’.  If everything goes well, the inventory count will be deducted in SmartTurn. We can then synchronise the latest inventory count to our Accounting System.

Below is a simple diagram illustrating the above scenario:

We can integrate SmartTurn with any other CRM, ERP system or etc. which improve efficiency in order processing and fulfillment. As with the above scenario, updating the customer information and purchasing details, processing the transaction before confirming shipment status and other details.