Setting up the Concert Data Apps data source

Edit online

Concert supports connections to various APIs and databases, including SQL, REST, and GraphQL. Configure your data source to start building apps with your data.

Before you begin

  • Create a project in Concert Data Apps.
  • You must have a working connection URI of the supported database.

Instructions

Refer to the following steps to configure your data source.
  1. Click Data Sources in the toolbar.
  2. Select the type of connection (SQL, REST, GraphQL). Refer to Data sources for more details on different data source types.
  3. Fill the required connection details.
    • SQL - Host, port, database, and credentials.
    • REST - Base URL and optional headers or auth.
    • GraphQL - Endpoint and headers.
  4. Click Save.

You can now select the required data source across widgets.

Use case: Setting up a PostgreSQL data source

Refer to the following steps to configure your PostgreSQL data source.

  1. Click Data Sources in the toolbar.
  2. Select Postgres.
  3. Complete the required connection fields.
    Table 1. Connection field
    Field Description
    Name A friendly label for this data source (for example, CustomerDB, AnalyticsDB).
    Host The server address where the database is hosted.
    Port The default port is 5432 for PostgreSQL. Change only if your database uses different port.
    User Your database username with read or query access.
    Password The password associated with the user account.
    Database The database name that you want to connect to (not the server name).
  4. Enable SSL if your database requires an SSL-encrypted connection.
  5. Click Save.

Your Postgres endpoint appears under My data sources.

Use case: Setting up a Rest data source

Refer to the following steps to configure your REST data source.
Note: For demonstration purposes, the section uses a REST dummy JSON data source.
  1. Click Data Sources in the toolbar.
  2. Under REST, select REST.
  3. Name your data source and enter the API URL: <https://dummyjson.com>.
  4. Click Save.

Your REST endpoint appears under My data sources.

Use case: Setting up a Concert data source

Refer to the following steps to configure your Concert data source.

  1. Click Data Sources in the toolbar.
  2. Under REST, select Concert.
  3. Name your data source and enter the API endpoint. Use the following as your base endpoint: 
    </core/api/v1>

    Refer to the Concert API documentationfor a full index of endpoints and requests.

  4. Click Save.

Your Concert endpoint appears under My data sources and you can select in any widget under the Data Source option.

Next step

If your data source is connected, then you can execute a Concert Data Apps query, refer to Execute a Concert Data Apps query.