StarfishETL

Blog

Managing Cloud CSV File Sharing with StarfishETL

Using CSV files for customer data may be an old school strategy, but many businesses still prefer the format. Before we get into how StarfishETL can help manage CSV file sharing, especially over the cloud, let’s take a moment to understand why businesses choose these types of files over another medium, and the challenges they must overcome to effectively put them to work.

Continue reading
header image
Blog

How to Decide Which Version of StarfishETL is Right for You

Everyone loves options, right? As you prepare for your data project, you may notice StarfishETL offers several options for moving your data. How do you know which version of the platform is right for what you need, though? The first thing you must consider is what you’re using StarfishETL for: integration, migration, data clean up, process automation, or other uses. Here are some descriptions and guidelines to help you choose the best StarfishETL instance for your next project.

Continue reading
header image
Blog

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.

Continue reading
header image
Video

Scripting a Field and Using a Global Script with StarfishETL

In this video we look at using a script to transform origin data into another format for use in a destination system. We also look at using a Global Script to create a helper function to handle the possibility of our origin returning a null object for an origin data point.

Continue reading
Blog

Fixing the "Unable to translate bytes..." Error When Using the "CSV via Upload" Connector in StarfishETL

This error message is generally caused by “unknown, unrecognized, or unrepresentable characters”. You can find out if there is an issue with your file by opening the file in a text editor.

Continue reading
header image
Blog

Introducing StarfishETL’s MS Exchange Graph API Connector

The wait is over! We are happy to announce a new connector for StarfishETL: the Exchange Graph API connector is now available. This will be a faster, more-secure connector for your Microsoft 365 integrations using StarfishETL.

Continue reading
header image
Blog

How to Create a Connection in StarfishETL

The connection is what allows you to have read/write access to the modules you need. It tells your connecting solutions, “Hey! I want StarfishETL to be able to access your data. Grant it the permissions it needs to do this migration or integration correctly.” Once the connection is in place, you can create your data map or use a pre-built map to build your project the way you prefer.  The data map is the plumbing that determines how your data flows. 

Continue reading
header image
Blog

Integrate ERP Through Your Firewall with the StarfishETL Ray

Many companies want full Cloud adoption, but simply aren’t “there” yet, so they must strike a balance between their locally hosted systems and the Cloud software. However, when it’s time to integrate the two, things can get complicated. Your only options to integrate ERP through a firewall are to either work locally or expose the software over the firewall – neither of which are desirable approaches.

Continue reading
header image
Blog

Expert Integration Tips: StarfishETL Error Handling

Try as we may, many of us still run into unexpected errors when executing integrations. In the world of unpredictable data, these errors are inevitable. They can occur from human miscalculations, incorrect information, malfunctioning systems, or any other number of random events.

Continue reading
header image
Video

Introduction to StarfishETL Designer

Watch this quick overview to learn the basics of the StarfishETL Designer.

Continue reading
Video

Starfish User Interface Overview

This video provides a basic overview of the StarfishETL user interface.

Continue reading
Video

3 Unique Ways to Use StarfishETL

StarfishETL can do more than simple data migration and integration. Here are just three of its many uses.

Continue reading
Video

StarfishETL Intro

Watch this quick video for an intro on the power of StarfishETL.

Continue reading
Blog

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 migrating from. In such as situation, the database returns numeric codes for picklist values instead of their actual text. This makes it hard to work with because of the need to manually translate each number to…

Continue reading
header image
Video

StarfishETL Demo

What does a StarfishETL data migration look like? Take a look at this demonstration as we show a sample CRM data migration.

Continue reading