SAP IQ (formerly Sybase IQ) is a column-oriented relational database management system designed for high-performance analytics and data warehousing. Integrate Validio with your SAP IQ database to monitor, analyze, and validate your data assets.

To integrate with SAP IQ,

1. Create a user in SAP IQ with the appropriate permissions for Validio. See Prerequisites.
2. Create a Validio credential to connect to the SAP IQ account. See Add a SAP IQ Credential.
3. Create a Validio source to monitor the tables in the SAP IQ database. See Add a SAP IQ Source.

Prerequisites

Create a user in SAP IQ with read-only access so that Validio can read and validate your data. For more information about credentials in Validio, see Credentials.

The following SQL script provides steps for setting up a user with the necessary permissions for the source in Validio. Run it as a user with administrative privileges:

-- Create the Validio user.
CREATE USER Validio IDENTIFIED BY '<password>';

-- Allow Validio to list the databases on the server.
-- sa_db_list is a system procedure owned by dbo.
GRANT EXECUTE ON dbo.sa_db_list TO Validio;

-- Grant read access to the system catalog views that Validio uses to
-- discover tables, schemas, and views, and to infer table schemas.
GRANT SELECT ON SYS.SYSTAB TO Validio;     -- Tables
GRANT SELECT ON SYS.SYSUSER TO Validio;    -- Users (schemas)
GRANT SELECT ON SYS.SYSOBJECT TO Validio;  -- Views and tables
GRANT SELECT ON SYS.SYSREMARK TO Validio;  -- Notes/descriptions
GRANT SELECT ON SYS.SYSTABCOL TO Validio;  -- Table columns
GRANT SELECT ON SYS.SYSDOMAIN TO Validio;  -- Fallback column type

-- Grant read access to each table you want Validio to monitor.
GRANT SELECT ON <owner>.<table> TO Validio;

📘

Catalog grants and row filtering

The system catalog views (SYS.*) are readable by PUBLIC by default in SAP IQ, so the catalog grants above may already be in effect — they are included to make the requirement explicit. The grants that always matter are CREATE USER and EXECUTE on dbo.sa_db_list.

Catalog row filtering still applies: even with SELECT on the catalog views, the user only sees catalog rows for objects it has a privilege on. Grant SELECT on each table you want Validio to monitor so it can infer and validate their schemas.

Add a SAP IQ Credential

[TODO: screenshot needed - SAP IQ credential configuration]

To add a credential for SAP IQ,

1. Navigate to Credentials and click + New Credential.
2. Under Namespace, select a namespace where the resources will be created.
3. For Credential Type, select SAP IQ.
4. Fill in the credential parameter fields. Refer to the SAP IQ Credential Parameters table.
5. (Optional) Click Test credential to validator the connection to the SAP IQ account. If validation fails, check that you provided the correct parameter values and try again.
6. (Optional) Check Use for catalog and schema checks to automatically discover assets and add them to the catalog page.
7. Click Create.

Once the credential is created, you can add a source to start monitoring SAP IQ data.

SAP IQ Credential Parameters

Add a SAP IQ Source

[TODO: screenshot needed - SAP IQ source configuration]

To add a source for SAP IQ,

1. Navigate to Sources and click + New source.
2. Under Source type, select SAP IQ.
3. Under Config,
   1. Select the valid Credential or create a new credential to authenticate your connection to the database.
   2. You have two options for specifying the dataset and tables to monitor:
      1. Select an existing table -- Enter the Database, Schema, and Table to specify where the data comes from. Selecting more than one table will create a new source for each table. Refer to the Source Configuration Parameters table.
      2. Use Custom SQL -- Write a valid SQL query to specify the data to monitor. See Custom SQL Sources.
   3. Set the Polling schedule, which is how frequently the validators on the source will check for changes.
4. Under Schema, click Continue to automatically infer the schema fields from the tables you selected. If you select many tables, this operation can take a few minutes to complete.
5. Under Source details,
   1. Add Tags to help group related sources or to use for routing notifications.
   2. Add an Owner who will be the contact for incident notifications.
   3. Assign a Priority, which indicates the importance of incidents detected on this source.
6. Click Continue to create the source.
   Source names are generated automatically and will be displayed when the source creation completes. If there are more than 5 sources, you will see the names for the first five and a count of the remaining sources.

SAP IQ Source Configuration Parameters