Adding data from files and databases

You can add data to your app quickly, by clicking Add data in the Data manager or in the ¨ menu.

You can add data from the following types of data sources:

• Connections

  Add data from data connections that have been defined by you or an administrator, and folders that you previously have selected data from.

• Connect my data

  Add data from a new data source, such as ODBC or OLE DB databases, data files, web files or custom connectors.

  Tip noteYou can also drop a data file on the Qlik Sense Desktop window to add a data file.

• Qlik DataMarket

  Select from normalized data from public and commercial databases.

  See: Adding data from Qlik DataMarket

• Attach file

  Upload a data file from your computer and attach it to your app.

Adding data from an existing data source

You can select data from connections that have already been defined by you or an administrator. These can be a database, a folder containing data files, or a custom connector to an external data source, such as Salesforce. Folders you have selected data from previously are also available here.

Do the following:

1. Click Add data.
2. Click Connections.

3. Select which connection to use.

4. Select which specific data source you want to add data from. This differs depending on the type of data source. The most common

   • File-based data sources: Select a file.
   • Databases: Set which database to use.
   • Web files: Enter the URL of the web file.
   • Other data sources: Specified by the connector.

5. Select the tables and fields to load.

   See: Selecting data fields from your data source

   If you want to bypass the data profiling step, you can continue to step 8.

6. Click Profile.

   The data will be profiled to provide field association recommendations.

7. If the data profiling resulted in recommendations, they are displayed, and you get assistance with validating and improving table relationships, for example, adding relationships, or removing relationships by renaming one or more fields.

   See: Managing data table associations

8. Click Load and finish.

Adding data from a new data source

You can select data from a data source that you have not used before. There are a number of types of data source available.

Do the following:

1. Click Add data.
2. Click Connect my data.

3. Select which type of data source to use.

4. Select which specific data source you want to add data from.

   • File based data sources: Select a file.
   • Databases: Set which database to use.
   • Web files: Enter the URL of the web file.
   • Other data sources: Specified by the connector to the database.

5. Select the tables and fields to load.

   See: Selecting data fields from your data source

   If you want to bypass the data profiling step, you can continue to step 8.

6. Click Profile.

   The data will be profiled to provide field association recommendations.

7. If the data profiling resulted in recommendations, they are displayed, and you get assistance with validating and improving table relationships, for example, adding relationships, or removing relationships by renaming one or more fields.

   See: Managing data table associations

8. Click Load and finish.

Attaching data files

If you are using Qlik Sense on a server and you want to use data files from your computer, you can upload the data files and attach them to an app. An attached file is only available in the app that it is attached to.

Attaching a new file

Do the following:

1. Click Add data.
2. Click Attach file.

3. Drop a data file, or click and select a file from your computer to load.

4. Select the tables and fields to load.

   See: Selecting data fields from your data source

   If you want to bypass the data profiling step, you can continue to step 8.

5. Click Profile.

   The data will be profiled to provide field association recommendations.

6. If the data profiling resulted in recommendations, they are displayed, and you get assistance with validating and improving table relationships, for example, adding relationships, or removing relationships by renaming one or more fields.

   See: Managing data table associations

7. Click Load and finish.

Deleting an attached file

Do the following:

1. Click Add data.
2. Click Attach file.

3. Click E next to the file you want to delete.

4. Click ‰ to exit Add data.

Which data sources are available to me?

The data-source types that are available to you depends on a number of factors:

• Access settings

  Administrator settings determine which types of data sources you can connect to.

• Installed custom connectors

  Qlik Sense contains built-in support for many data sources. To connect to additional data sources you may need a custom connector, supplied by Qlik or a third party. Custom connectors need to be installed before you can use them.

  Qlik Sense Custom Connectors help

• Local files availability

  Local files on your desktop computer are only available in Qlik Sense Desktop. They are not available on a server installation of Qlik Sense.

  Tip noteIf you have local files that you want to load on a server installation of Qlik Sense, you need to transfer the files to a folder available to the Qlik Sense server, preferably a folder that is already defined as a folder data connection.