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.
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
Features that require Development credentials
Running a Draft workflow
System-specific Connector Requirements
SFTP Servers
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
Last updated
Was this helpful?