We're extremely proud today to be announcing the release of StarfishETL 4.0. In recent versions, a number of connectors have been redeveloped from the ground up including Salesforce, SData, Email, and Sage CRM. In this release, we've taken this opportunity to remove the old/deprecated versions... Continue Reading
When migrating data from Dynamics CRM, there might be a need to determine which specific objects have Activities such as "Tasks" associated with them. This is especially important in the context of data cleansing because one might not want to migrate data that has not had any activity(tasks)... Continue Reading
We recently had a migration from ACT to Salesforce. One of the migration steps was to create Account records in a staging database from ACT Contacts. The source had 24,000 records and there were matching rules on three fields: Address1, City, and Company Name.
It took 15 minutes to get... Continue Reading
We recently ran into an issue in our StarfishETL data integrations between a back-end ERP system and Infor CRM. We noticed that Date/Time fields were imported successfully via the OLEDB provider but displayed incorrectly inside the CRM application.
Infor CRM was doing the GMT adjustment... Continue Reading
When importing data into SugarCRM using Starfish, users will generally want to disable the Assignment Notification functionality in the Admin -> Email Settings area of SugarCRM.
We're celebrating the release of StarfishETL 3.0 with the addition of 2 brand new connectors. It's been several months in the works and we hope it's been worth the wait.
Now setting up even the most complex system integrations can be simplified with the added power of C# as a scripting language! We're excited to announce now with Starfish ETL 2.9, you can use C# scripting at all levels of your data integration and migration jobs. With the full power of the .NET... Continue Reading
One of the benefits of StarfishETL is that it's Engine (where all the magic happens) is Web-services based. This means not only can StarfishETL itself run in the cloud, but you can control it programmatically through it's SOAP interface. You can tell the server to begin processing a job with a... Continue Reading
Using the latest StarfishETL, you can easily upload or migrate your attachments to an On-Demand SugarCRM instance by using the new Base64 conversion functions.
Here is a generic example of how you would migrate attachments from another database to SugarCRM.