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 ...
System Backup Wizard
The Starfish ETL System Backup Wizard will walk you through a series of steps to create a complete backup framework for any system. The System Backup Wizard does not actually back up any data during this process, it only creates the tables and jobs ...
DateTime Fields Note that when working with "DateTime" fields in SQLite, the value saved in the field and used for comparison operations must match one of the 10 allowed formats: https://www.sqlite.org/lang_datefunc.html. Starfish's FormatDate ...
Microsoft SQL Server Connector
Overview The "SQL Server" Connector pulls data from Microsoft SQL Server. Using rowversion fields Many integrations run frequently and only want to pick up records modified since the last time the integration ran. This can be accomplished with ...
Pipedrive Connector SQL Select Statements
The API Profile supports SQL-92 Syntax. SELECT Statements includes a comprehensive list of the supported keywords and clauses, as well as syntax reference and examples. Select StatementsLast Modified - A SELECT statement can consist of the following ...