Working with Starfish Variables

Working with Starfish Variables

 Starfish variables can be used to store configurable information used by jobs and scripts. In the example below, several Variables have been defined.

Use the following steps to walk through
  1. Viewing variables
  2. Selecting and changing a variable

  1. Navigate to the Project’s Variables tab


  1. Modify the server time offsets to reflect the time differences of each server
  2. ServerTimeOffset-HubSpot – typically US Central time
  3. ServerTimeOffset-Creatio
  4. StarfishETL iPaaS is on US Central Time


  1. Change ClosedWon and ClosedLost Opportunity Type Ids if different from current selection


  1. Specify User Ids for each Starfish user


  1. Specify the default sales representative for Creatio. This will be used to assign the Leads.


New variables can be created by selecting the New action at the upper left most part of the Variable grid.
    • Related Articles

    • Working with Cross References (Xref files)

      Working with Cross References (Xref files) Xref files servermany purposes. The most common case is as foreign key lookups. Another common case is to use Xrefs as pick list lookups. Tables can be created manually. They can be created by importing the ...
    • Starfish Scripting Class Object

      From within VBScript operations (ScriptedVariable, VBScriptProcedure, ScriptedField) in additional to normal VBScript functions, the developer has access to a custom “Starfish” class. The tables below define its usage. This class may also be used ...
    • Starfish Engine

      The server where the Engine will be installed must have IIS and ASP.NET installed. Microsoft .NET Framework 4.0 is required. For the installation package to function properly on some later operating systems, "IIS 6 Management Compatibility" may also ...
    • Starfish ETL iPaaS Logging Features and Settings

      Starfish ETL iPaaS Logging Features and SettingsStarfish ETL iPaaS has a number of options for logging and monitoring integration activity. Logging is required at various stages of the integration mapping process, during the testing phase prior to ...
    • Working with MultiSelect Lists

      For this example we use SugarCRM, where MultiSelect fields are supplied as a JSON string, i.e. [{"value1","value2"} First, I check to make sure my origin value ('reg') and existing value in Sugar ('existing') are not empty, as either case is easy to ...