OLE DB
Qlik Sense supports the
OLE DB data connection settings
UI item | Description |
---|---|
Provider |
Select Provider from the list of available providers. Only available when you create a new connection. |
Data source |
Type the name of the Data source to connect to. This can be a server name, or in some cases, the path to a database file. This depends on which Example: If you selected C:\Users\{user}\Documents\Qlik\Sense\Apps\Tutorial source files\Sales.accdb Warning: If a connection to the data source fails, a warning message is displayed.
|
Connection string | The connection string to use when connecting to the data source. This string contains references to the Provider and the Data source. Only available when you edit a connection. |
Windows integrated security | With this option you use the existing |
Specific user name and password | With this option you need to enter User name and Password for the data source login credentials. |
Username |
User name to connect with, if required by the data source. Leave this field empty if you use Windows integrated security or the data source does not require credentials. |
Password |
Password to connect with, if required by the data source. Leave this field empty if you use Windows integrated security or the data source does not require credentials. |
Load
Select database... |
If you want to test the connection, click Load and then Select database... to use for establishing the data connection. Note: You are still able to use all other available databases of the data source when selecting data from the data connection.
|
Name | Name of the data connection. |
Security aspects when connecting to file based OLE DB data connections
If this is a concern, it is recommended that you connect to the data file using a folder data connection if it is possible.
Stopping preview of large datasets in tables
If you have large data sets and you do not want to see a data preview while adding