Working with Variables

Working with Variables

StarfishETL 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 StarfishETL 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 ...

    • 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 ...

    • 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 ...

    • Active Directory Connector

      Origin There may be some trial and error with capitalization required to get this Origin working. For example, ldap://ad.xyz.com vs LDAP://ad.xyz.com or LDAP://ad.xyz.com vs LDAP://ad.XYZ.com. Parameter Description Access Key Connection String Active ...

    • Previewing Jobs

      Before running a job for the first time, you can check to make sure all your formulas and translations are working correctly by stepping through each row on the Preview tab. No data will be modified in your destination system, and you may click Log ...