Blog

Infor integrations
how to cross reference

Generating StarfishETL Cross-Reference Files from MSCRM Picklists

Generating StarfishETL Cross-Reference Files from MSCRM Picklists

When using Starfish to migrate from Microsoft Dynamics CRM to a different CRM system, you may need to create cross reference files that translate picklist codes to actual text values. This is particularly true if you don’t have a full Dynamics CRM instance setup for the database you are... Continue Reading

bpm'online connector setup

Easier connection setup, bpm'online connector & more

Easier connection setup, bpm'online connector & more

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

migrating dynamics crm objects

Deciding Which Dynamics CRM Objects to Migrate Based on Associated Activity

Deciding Which Dynamics CRM Objects to Migrate Based on Associated Activity

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

the power of indexing

The Power of Indexing

The Power of Indexing

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

data offsets

Infor CRM Date Offsets With StarfishETL

Infor CRM Date Offsets With StarfishETL

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

importing data into SugarCRM

StarfishETL: Assignment Notification When Importing Data into SugarCRM

StarfishETL: Assignment Notification When Importing Data into SugarCRM

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.

quickbooks and exchange connectors

New QuickBooks and Exchange Connectors

New QuickBooks and Exchange Connectors

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.

c sharp scripting

Enhance your ETL jobs with C# Scripting

Enhance your ETL jobs with C# Scripting

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

manage starfishetl

Manage StarfishETL Programmatically

Manage StarfishETL Programmatically

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

Pages