Skip to main content

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 Data Connections, making it easier to add more data from the same data source.

Warning note

Do not add a table in Data manager that has already been added as a scripted table with the same name and same columns in Data load editor.

For more information about:

You can delete connections from Add data by right-clicking the connection and selecting Ö Delete connection.

Warning note

If you delete a connection, you must delete any tables from Data manager that used that connection before you load data.

Do the following:

  1. Open an app.
  2. Open the Data manager and then click ú. You can also click Add data in the ¨ menu.
  3. Under Connect to a new data source, select a source.
  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. Select Filter data if you want to select a subset of the data contained in the fields you have selected.

    When you select Filter data, a text box opens for the filter criteria. For information about criteria, see Filtering data.

    Note the following:

    • Filters are applied to field names from the database. If you rename a field in the Data manager, you have to apply the filter to the original field name from the database. For example, if a field is named EMP in your database, and you rename it to EMPLOYEE in the Data manager, you have to apply the filter EMP = ‘filter_value’ .
    • You can clear data filters in the Associations view of the Data manager. For the changes to take effect, reload data by clicking the Load data button. You have to split concatenated tables before clearing filters.
    • Filtering data is not currently available for all connectors, or for attached files or Qlik DataMarket.
  7. Click Add data to open the data in the Associations view of the data manager. This allows you to continue to add data sources, transform the data, and associate the tables in Data manager.

    Data profiling is enabled by default when you click Add data. Data profiling does the following:

    • Recommends data associations.
    • Auto-qualifies common fields between tables. This adds a unique prefix based on table name.
    • Maps date and time fields to autoCalendar.

    Tables are not associated on common field names automatically. You can associate tables in the Associations view.

    Tip noteIf you want to load the data directly into your app, click ¥ and then disable data profiling. This will also reload all existing data from data sources when you add the data. Tables will be associated on common field names automatically. Date and time fields will not be created.

    See: Managing data associations

  8. Click Load data when you are done preparing the data. If serious problems are detected, you need to resolve the problems in Data manager before you can load data into the app.

    See: Troubleshooting - Loading data

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!