Data Connectors

Glyue ETL uses Data Connectors to manage access to external systems, such as SFTP servers and CRMs like HubSpot and Creatio. The requirements for each data connector differs based on the specific system, but the basics are outlined further down on this page.

A data connector only manages access credentials and does not specify the exact records being accessed or modified. The exact records are instead specified on the workflow's configuration when the connector is selected. This allows the same connector to be used across multiple workflows — it can grant access to different files for different workflows from the same SFTP server, or write to different objects in a HubSpot instance, for example.

Some data connectors may be "source only" or "destination only".

Development vs. Production Credentials

A connector actually contains two sets of credentials — one for development purposes, and another for production uses. While Glyue ETL does not enforce what type of system you enter credentials for, it is strongly recommended that you adhere to best practices and only enter SDLC-appropriate credentials.

A data connector only requires that one set of credentials is populated. However, missing credentials for one system will disable certain features, detailed below:

• Features that require Production credentials

  • Setting a schedule for a workflow

Scheduled workflows always run using production credentials.

• Features that require Development credentials

  • Running a Draft workflow

System-specific Connector Requirements

SFTP Servers

Field	Meaning	Example
Hostname	The URL of the SFTP server	sftp.sandboxbanking.com
Port	The exposed port of the SFTP server. Defaults to 22	22
Username	The username of the account to be used to access the SFTP server	Varies
Authentication Method	How the account should authenticate with the SFTP server. Is either a password, or an authentication certificate.	Password or Private Key (Certificate)
Authentication Credentials	Depending on the authentication method, either the password or the certificate.	Varies

HubSpot

Glyue ETL's HubSpot connector leverages browser-based OAuth, meaning connection only requires logging into your HubSpot account from Glyue ETL.

The Date Format field specifies the date format sent to HubSpot, as HubSpot requires a consistent date format across all date values. In most cases, the default value is appropriate and does not need to be changed.

Oracle SQL