Posts Tagged ‘data integration’

Integration Tips: Synchronize Picklist Value Part 1

Different system has different way to manage the picklist values. For integration, it is important to understand how the picklist values are represented in API. Here are some of the types of picklist values can be appeared as:   1. Value is represented by same value as front-end   For example in Salesforce, the “Ownership”…

Read More

Magento Integration: Product Type

Magento supports a few product types. Each product type has different behaviour. This is important when you design the product synchronisation process.   For example, if you are integrating Salesforce and Magento in the following scenario: Magento Order > Creates > Salesforce Opportunity   If one of the order line items is a bundle product,…

Read More

About to integrate existing systems, how’s the quality of your data?

When we kickoff our integration projects we run through a checklist with the client. If they have been running the systems for a period of time, we always review the quality of the data, we call it a Data Quality Assessment (someone in marketing came up with that, not me, ok). Usually, the client asks:…

Read More

TIM’s Tip: CSV integration

TIM here again – with another Tip, hope it’s helpful. Boss: TIM, I need you to integrate CSV to Salesforce. TIM: CSV integration? How hard can that be? I can do it in one day.   A day after… Boss: TIM, have you completed that CSV integration? TIM: Hmmm, Boss, I need more time to…

Read More

TIM’s Tip: bi-directional data integration

TIM here again – with another Tip, hope it’s helpful. In my experience integrating various SaaS applications such as Salesforce, Netsuite, Parature, RightNow, JIRA, etc,  bi-directional integration is a popular requirement. So, why use bi-directional integration? Consider a bi-directional update between the Salesforce and RightNow Account Objects as an example: When the record in Salesforce…

Read More

How to integrate with MYOB Accounting

MYOB Accounting Plus and Premier use an underlying data file to hold the records. In the current versions, this is not a relational database, making traditional integration difficult. MYOB have over the years released a series of ODBC drivers. These have allowed programs such as Word and Excel to extract data and in some cases, insert…

Read More