Data Integration Connectors
- Data Integration Connectors
- All Products
ASK INFAPreview
Please log in to access Ask INFA.
ASK INFAPreview
Property | Description |
|---|---|
Connection Name | Name of the connection. Each connection name must be unique within the organization. Connection
names can contain alphanumeric characters, spaces, and the
following special characters: _ . + -, Maximum length is 255 characters. |
Description | Description of the connection. Maximum length is
4000 characters. |
Use Secret Vault | Stores sensitive credentials for this connection in the secrets manager that is configured for your organization.
This property appears only if secrets manager is set up for your organization.
When you enable the secret vault in the connection, you can select
which credentials that the Secure Agent retrieves from the secrets manager. If you
don't enable this option, the credentials are stored in the repository or on a local
Secure Agent, depending on how your organization is configured. If you’re using this connection
to apply data access policies through pushdown or proxy services, you cannot use
the Secret Vault configuration option. For information about how to configure and use a secrets manager, see
"Secrets manager configuration" in the Administrator help .
|
Runtime Environment | Name of the runtime environment where you want to
run tasks. |
Client Id | Required. The Client ID from Google Developer
Console. |
Client Secret | Required. The Client Secret from Google Developer
Console. |
Refresh Token For Sheet | Required. The Refresh Token received after
exchanging authorization code for Google Sheets. |
Refresh Token For Drive | Optional. The Refresh Token received after
exchanging authorization code for Google Drive. This option is
required when you enter the spreadsheet name in the
Spreadsheet Name field. |
Spreadsheet Name | Name of the spreadsheet in Google Sheets. |
Spreadsheet Id | ID of the spreadsheet in Google Sheets. |
Initial Column Range | Specifies the first column name from a data range
in a Google Sheets spreadsheet from where you want to start reading
the data. For example, specify the Initial Column Range value as
Sheet1!C5. |
Final Column Range | Specifies the last column name from a data range
in a Google Sheets spreadsheet from where you want to stop reading
the data. For example, specify the Final Column Range value as
Sheet1!G20. |
Header Present | Select this option to indicate that the sheet
contains a header. If you select this option and the sheet does not
contain a header, the first row is treated as the header. |
Create New Spreadsheet | Select this option to create a new spreadsheet in
Google Sheets. The Google Sheets Connector creates an empty
spreadsheet with the name that you specified in the
Spreadsheet Name field.Once
you test the connection, disable this option. Otherwise, the
Google Sheets Connector will create a new spreadsheet with the
same name every time. |
