Connection
This section provides a complete list of the Connection properties you can configure in the connection settings for this provider.
| Property | Description |
| ConnectionType | Specifies the file storage service, server, or file access protocol through which your Microsoft Excel files are stored and retreived. |
| URI | The Uniform Resource Identifier (URI) for the Excel resource location. |
| DefineTables | Map Excel ranges to table names. |
| Header | Indicates whether the first row should be used as a column header. |
| Orientation | Indicates whether the data in Excel is laid out horizontally or vertically. |
| ExcelFile | The location of an Excel file. |
| BufferChanges | Indicates whether to hold changes to the data in memory until the connection is closed. |
| Region | The hosting region for your S3-like Web Services. |
| ProjectId | The Id of the project where your Google Cloud Storage instance resides. |
| OracleNamespace | The Oracle Cloud Object Storage namespace to use. |
| StorageBaseURL | The URL of a cloud storage service provider. |
| UseVirtualHosting | If true (default), buckets will be referenced in the request using the hosted-style request: http://yourbucket.s3.amazonaws.com/yourobject. If set to false, the bean will use the path-style request: http://s3.amazonaws.com/yourbucket/yourobject. Note that this property will be set to false, in case of an S3 based custom service when the CustomURL is specified. |
| UseLakeFormation | When this property is set to true, AWSLakeFormation service will be used to retrieve temporary credentials, which enforce access policies against the user based on the configured IAM role. The service can be used when authenticating through OKTA, ADFS, AzureAD, PingFederate, while providing a SAML assertion. |