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 migrating from. In such as situation, the database returns numeric codes for picklist values instead of their actual text.
Chicago, IL - (May 1, 2017) –Technology Advisors Inc. (TAI), a business & technology consulting company specializing in custom software integrations and enterprise-level CRM projects, teamed up with data migration and integration service, StarfishETL, to build an integration between SugarCRM and Epicor ERP.
Migration Service Offers New Connectors & Improved Functionality
We're extremely proud today to be announcing the release of Starfish ETL 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 of these connectors. We've also cleaned up our codebase by eliminating unnecessary dependencies which should result in faster software loading times.
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) against it in a while.
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.
We recently ran into an issue in our Starfish ETL 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.
Starfish ETL is releasing four new connectors compatible with marketing automation (MA) software from providers like Pardot, Act-On, Hubspot, and Marketo.
Premier Import/Export Suite Offers More Ways to Connect
Data migration and integration tool, Starfish ETL (extract, transform, load) announced three new connectors to the software. The first of these connectors was launched in early November for SMS/MMS messaging. The second two connectors, released this week, support Twitter and Facebook integrations. The additions offer new communication possibilities for end users.
Using our new Twilio connector, you can use Starfish ETL to orchestrate the sending and receiving of text (SMS) messages. You can also send and receive picture (MMS) messages! Starfish can retrieve messages that are sent to your Twilio number and from there the possibilities are endless. Open support tickets, facilitate sales, customer notifications..
G2 Crowd recently listed Starfish ETL among Chicago’s top-rated business software programs based on user satisfaction and market presence. The top companies were determined using G2 Crowd’s first Chicagoland GridScape, which uses real-time visualization of business software products to evaluate each offering.
Starfish now supports using a SQLite database for Cross-Reference (Xref) tracking. This has the advantage of allowing you to read and write an xref in the same job. In addition, if you initialize the xref in append mode, it will append new items to the list but also update records that already exist. With the file system xref lists, records would be duplicated instead of updated.