Dynamic account types
Dynamic Accounts provide expression-enabled fields, which allow you to use expressions for connection information instead of literal values. You can 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 |
|---|---|
| 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 | Databasename, 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, DatabaseName, 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 |