Adding data from a new data source

You can add data to your app from a new data source. When you add data from a new data source, a connection to the data source is created in Connections, making it easier to add more data from the same data source.

See: Connecting to data sources

Do the following:

1. Click Add data in the Data manager or in the ¨ menu of any other view.
2. Click Connect my data.

3. Select the type of data source to use.

4. Enter the connection parameters required by the data source.

   For example:

   • File based data sources require that you specify a path to the files and select a file type.
   • Databases such as Oracle and IBM DB2 require database properties and access credentials.
   • Web files require the URL of the web file.
   • ODBC connections require DSN credentials.

5. Select the tables and fields to load.

   See: Selecting data fields

6. Choose whether to continue to work on the data or to load the data into the app:

   • Click Prepare data to continue to add data sources, transform the data, and associate the tables in Data manager. Date and time fields will be created automatically. Data profiling is also performed to provide association recommendations. All fields that are common between tables are auto-qualified.

     Information note Tables are not associated on common field names automatically, and you need to associate all tables in the Associations view of Data manager.

   • Click Load data and finish to load the added data into the app and go to the sheet. This will also reload all existing data from data sources.

     Tables are associated on common field names automatically.

     Information noteDate and time fields will not be created if you use Load data and finish.

   If serious problems are detected, you need to resolve the problems in Data manager before you can load data into the app.

Which data sources are available to me?

What data source types 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 connectors

  Qlik Sense contains built-in support for many data sources. Built-in connectors are installed automatically by Qlik Sense. To connect to additional data sources you may need to install connectors separately that are specifically for those data sources. Such separately installed connectors are supplied by Qlik or a third party.

  See: Troubleshooting - Loading data

  Qlik Connectors help

• Local file availability

  Local files on your desktop computer are only available in Qlik Sense Desktop. They are not available for use with 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 attach the files to the app, or transfer the files to a folder available to the Qlik Sense server, preferably a folder that is already defined as a folder data connection.