Dynamic Account Types

Dynamic Accounts provide expression-enabled fields, which allow you to use expressions for connection information instead of literal values. You can then pass in the values as Pipeline parameters, or if your Org is using Secrets Management, a dynamic Account can store the values necessary to access a secrets manager.

The following table lists the available dynamic account types. If you require a type that is not supported, contact your SnapLogic representative.

Account Type

Dynamic Fields

Account Type

Dynamic Fields

Amazon DynamoDB

AWS Access Key ID, AWS Secret Key, AWS Security Token, AWS Endpoint, AWS Region

Amazon Redshift

Endpoint, Port number, Database name, Username, Password, S3 Bucket, S3 Folder, S3 Access-key ID, S3 Secret key, S3 Security Token

Amazon S3 Dynamic

Access-key ID, Secret Key

Google Analytics Dynamic OAuth2

Access token

Google BigQuery Dynamic OAuth2

Access token

Google Directory Dynamic OAuth2

Access token

Google Dynamic OAuth2

Access token

Google Sheets Spreadsheet Dynamic OAuth2

Access token

Microsoft Azure SQL Active Directory Dynamic

Account properties

Microsoft Azure SQL Dynamic

Account properties

Microsoft Dynamics AX Dynamic AX

Username, Password, Domain, AIF endpoint, Object type

Microsoft Exchange Online Dynamic OAuth2

Access token, Access Token Type

Microsoft SQL Server Dynamic

Hostname, Port number, Database name, Username, Password

Microsoft OneDrive Dynamic

Access token, Access Token Type

Microsoft Teams Dynamic OAuth2

Access token, Access Token Type

MySQL Dynamic

Hostname, Port number, Database name, Username, Password, SSH tunnel parameters

MongoDB Replica Set Dynamic

Database name, Username, Password

OpenAPI Dynamic OAuth2

Access Token

Oracle JDBC Thin Dynamic

Hostname, Port number, Database name, Username, Password

PostgreSQL Dynamic

Hostname, Port number, Database name, Username, Password

Remote Python Executor Dynamic

Hostname, Port, Token

REST AWS SigV4

Access-key ID, Secret Key, Security Token

REST Dynamic OAuth2

Access token

Salesforce.com Dynamic

Access token, Instance URL

Shopify Dynamic OAuth2

Access token, Store Name

Snowflake Azure Dynamic OAuth2

Azure properties, User token, Custom key

Snowflake S3 Dynamic

Hostname, Port Number, Username, Password, Database Name, Warehouse Name, S3 properties

Slack Dynamic OAuth2

Access token

Teradata Database Dynamic

Hostname, Port Number, Database, Username, Password

Workday Dynamic

Username, Password, Host, Tenant

Zuora Dynamic OAuth2

Access token, Base URL