Skip to main content
Version: I2022.3.0

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 cubes. It also contains aggregate-table instances that either you or the AtScale engine creates in a database that you specify.

info

> >

> > Attention > >
:::

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

Before you begin​

  • Ensure that your user ID in the Design Center is assigned the Super User role or is assigned the Manage Data Warehouses role permission.
  • Aggregate Database: Ensure that you know the database to use for aggregate tables to be built in the data warehouse. AtScale reads and writes aggregate data to this databse. The AtScale service account user must have ALL privileges for this database. BI tool user accounts should not have the select permission for this database.

Add an InterSystems IRIS Data Warehouse​

  1. Go to Settings > Data Warehouses and click Create Data Warehouse.

  2. In the Add a Data Warehouse dialog box, under Type of Data Warehouse, select InterSystems IRIS.

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

  4. Enter the name of the namespace configured in InterSystems IRIS.

  5. Enter the name of the External Connection ID. This input will be inherited by the Name value, but can be overridden by enabling the Override generated value slider.

  6. Enter the name of the Aggregate Schema for AtScale to use when creating aggregate tables. (AtScale will create the schema if one does not exist.)

  7. Specify the Data Warehouse as a Read-only source.

    • Select this option if AtScale will be configured to access this database with credentials that do not have permission to create new tables, or if you need to prevent AtScale from placing any aggregate tables in this data warehouse.
    • If Read-only source is enabled upon editing an existing data warehouse with aggregates present, all existing aggregates stored in this data warehouse will be deactivated.

Add an InterSystems IRIS Connection​

After setting up your data warehouse, you must add a connection to the data warehouse before you can run queries. You can establish multiple connections, with different configurations, to the same data warehouse. If multiple InterSystems IRIS connections are configured, you can assign which types of queries are permitted per connection (see Query Roles below).

  1. Expand the drop-down adjacent to the listed data warehouse and click Create a InterSystems IRIS Connection (or Add Terdata Connection if you have other existing connections).
  2. For Name, enter the name of your InterSystems IRIS connection.
  3. For Host, enter the host address where your InterSystems IRIS server resides.
  4. For Port, enter the port number to route transmitted data. The default port number is 1972.
  5. Enter the name of the namespace configured in InterSystems IRIS.
  6. (Optional) Specify any extra JDBC flags in the Extra JDBC Flags field only if you are certain that they are required.
  7. Select the Authorization type: Password.
  8. Enter the Username and Password to connect to InterSystems IRIS.
  9. Test the connection.
  10. Click Save to complete the setup.

Query Roles​

If multiple InterSystems IRIS connections are configured, you can toggle which types of queries (Large Interactive, Small Interactive or System) are permitted per InterSystems IRIS connection. A query role can be assigned to only one connection at a time.

Expand the drop-down for the InterSystems IRIS data warehouse to choose the allowed query roles for each connection:

  • Large Interactive Queries: Use this engine for large user queries. These are usually BI queries involving full scans of the raw fact table or ones that involve high-cardinality dimensions.
  • Small Interactive Queries: Use this engine for small user queries. These are usually BI queries that can be optimized by AtScale aggregates or ones that involve low-cardinality dimensions.
  • System Queries: Use this engine for AtScale system processing, such as building aggregate tables or querying system statistics. The System query role user must not be subject to resource limitation rules that would prevent it from building aggregate tables.