Posts Tagged ‘data migration’

We Did: Customer Data Migration and Deduplication

Challenge This customer offers a range of beauty and self-care products and services. The customer is using a 3rd party system to track the information of walk-in clients across the country. All of the clientele information is stored in a single system. This system requires human input which unfortunately leads to a lot of data duplication.…

Read More

WeDid: Salesforce Data Migration and Integration with HubSpot

Challenges This customer is currently in the IT market helping other businesses with their software deployment plan. HubSpot is the main system that is used throughout the years to track marketing prospects, qualify leads and also sales. The Data now needs to be contained between two systems – HubSpot and Salesforce- as opportunity will now…

Read More

New Release: Boomi OANDA Connector

You can now capture exchange rates in a target application (i.e. your sales application or website, etc.).   How? If you have an account with OANDA, you can automate and/or streamline this process by integrating using the Boomi OANDA Connector.   To find out more about what the OANDA connector can do for you, check out the…

Read More

Meet The Team – Hon Ming

Get to know more about Hon Ming! Hon Ming was born and raised in Kuala Lumpur, alongside his elder sister and brother. Like most of our staff, Hon Ming loves to be outdoors being physically active, over being inside (He does not enjoy reading). Hon Ming spent two years living and studying at University in…

Read More

Data Migration: Tips to clean up excel data

When we implement a new integration project, we often need to load historical data into a new system. For example, the customer may provide us with a CSV export and expect us to load the data into Salesforce.   Below are some Excel formula tips you may find them handy while cleaning up the data:…

Read More

Talend: Data deduplication with tUniqRow

In Talend, there are many components with data deduplication functionality. For example, I have discussed tFuzzyMatch in my previous blog. Here, we are going to look at data deduplication again by using tUniqRow component.   Use Case:  I have 5 contact records, all of them have a unique Id, different names and some records share the…

Read More

TIM’s Tip: Estimating a Data Migration exercise

Maybe you are thinking, what’s so hard, I just dump the data out of system 1 and insert it into system 2, maybe, maybe not. How long will it take to migrate your data from one or more systems to another system?   It really depends on a few factors: How easy is it to…

Read More