Skip to main content

Adding InterSystems IRIS Data Warehouses

An InterSystems IRIS data warehouse contains the tables and views that you want to import as fact datasets and dimension datasets into AtScale models. It also contains aggregate table instances that either you or the AtScale engine creates in a database that you specify.

info

To configure an InterSystems IRIS data warehouse, you must have a special AtScale license. Ask your sales representative about obtaining an InterSystems IRIS-enabled license.

Prerequisites

  • You must have the datawarehouses_admin or datawarehouses_manage realm role assigned in the Identity Broker.
  • You must know the schema to use for building aggregate tables in the data warehouse. AtScale reads and writes aggregate data to this schema, so the AtScale service account user must have ALL privileges for it. BI tool user accounts should not have the SELECT permission.

Add an InterSystems IRIS data warehouse

To add an InterSystems IRIS data warehouse:

  1. In Design Center, open the Datasources panel.

  2. Click the + icon at the top of the panel and select InterSystems Iris.

    image

    The Add Data Warehouse panel opens.

  3. Enter a unique Name for the data warehouse. AtScale displays this name in Design Center and uses it in log files.

  4. Enter the name of the External connection ID. You can optionally enable the Override generated value? toggle to default this value to the name of the data warehouse.

  5. Enter the name of the Namespace configured in InterSystems IRIS.

  6. Enter the name of the Aggregate schema, which AtScale uses when creating aggregate tables. You must create this; AtScale does not create one automatically.

  7. In the Custom function installation mode field, select Customer managed if you set up InterSystems IRIS in customer managed mode; otherwise, select None.

  8. In the Access Controls section, add the users and groups that you want to be able to access the data warehouse and its data. For more information on how data warehouse security works in AtScale, see About Data Warehouse Security.

  9. Add a connection to the data warehouse. You must have at least one defined to finish adding the data warehouse.

    1. In the Connections section, click Connection Required. The Add Connection panel opens.

    2. Complete the following fields:

      • Name: The name of the connection.
      • Host: The location of the IRIS server.
      • Port: The port number to route transmitted data. The default is 1972.
      • Extra JDBC flags: Optional. Any JDBC flags that are needed for the connection. Only specify flags if you're certain they're required. For an example, see the Connection logging section below.
    3. In the Authorization type field, select an authorization method, then complete the credential fields as needed:

      • Password: Enter the username and the password.
      • Kerberos: Enter the IRIS service principal name.
      • TLS: Enter the username, password, key store location, and key store password.
    4. (Optional) Click Test Connection to test the connection.

    5. Click Add.

  10. (Optional) If your data warehouse has multiple connections, you can configure their query role mappings. This determines which types of queries are permitted per connection. A query role can be assigned to only one connection at a time.

    In the Query Mapping section, select the connection you want to assign to each type of query:

    • Small Interactive Queries: Small user queries. These are usually BI queries that can be optimized by AtScale aggregates, or ones that involve low-cardinality dimensions.
    • Large Interactive Queries: Large user queries. These are usually BI queries involving full scans of the raw fact table, or ones that involve high-cardinality dimensions.
    • Aggregate Build Queries: Queries made when building aggregate tables. This mapping should be assigned to a connection that has more compute power, and that is not subject to resource limitations that would prevent it from building aggregate tables.
    • System Queries: AtScale system processing, such as running aggregate maintenance jobs and querying system statistics.
  11. Click Save Data Warehouse.

Connection logging

If you need to keep a log for the connection:

  1. On the Data Warehouses page, click the pencil icon next to the connection to edit it. The Edit InterSystems Iris Connection panel opens.

  2. In the Extra JDBC Flags field, enter there the name of the log file; for example: Iris.log

    Consider the following:

    • You can include a slash sign (/) before the log name: /Iris.log
    • You can put the log name in quotes: "Iris.log"
    • If a log file with that name already exists, AtScale appends new entries to it. If you want to delete the existing log and start a new one, add a plus sign before the name: +Iris.log
  3. Click Test connection to test the connection.

  4. Click Apply.

To review the log file created this way:

  1. Log in to the AtScale system.
  2. Go to the following directory (check your file system for detailed names): /opt/atscale/versions/VERSION-NAME/pkg/ENGINE-VERSION/
  3. Open the file with a text editor.