IBM AS/400 Connector

Overview

Data Discovery for IBM AS/400 (V7R3) connector is processed through the Generic JDBC connector.

Pod Residency: rdbms-scanner
Connection Method: JDBC Connection URL

Supported Scan Actions


Scan Type	Description
Catalog	This scan type will only retrieve the metadata in the database like details of schema, table, or column.
Catalog & Scan	OneTrust scans both metadata and data under the tables and returns the appropriate labels.

Credential & System Permissions

Important:

OneTrust recommends to adhere to your organization's security and infrastructure policy and include system engineer resources or other qualified subject matter experts to set up credentials on data sources. For specific instructions for how to enable these credentials, refer to your data source's implementation documentation, knowledge base and/or support resources.

Jar used for IBM iSeries: jt400-11.2.jar, use maven link here to download.

Sample JSON

JSON

{
    "connectionUrl":"jdbc:as400://<ip>:8471/DB;”,
    "driver_class_name":"com.ibm.as400.access.AS400JDBCDriver",
    "user”:”user”,
    "password":"*******",
    "fetch_size":"<integer>",
    "jdbc_query_timeout":"PT10M"
}

{
    "connectionUrl":"jdbc:as400://<ip>:8471/DB;”,
    "driver_class_name":"com.ibm.as400.access.AS400JDBCDriver",
    "user”:”user”,
    "password":"*******",
    "fetch_size":"<integer>",
    "jdbc_query_timeout":"PT10M"
}

Scan Profile Support

Note:

For additional details on scan profile configuration and management, see Setting Up Scan Profiles.

Limits

Maximum number of databases
Maximum number of schemas per database
Maximum number of tables per schema
Maximum number of rows per table

Scope

Include/Exclude Path Configurations:
- Database
- Schema
- Table

Troubleshooting

JDBC Driver Class Not Loading

CODE

initializedDriverDataSource: as400 java.lang.IllegalStateException: Could not load JDBC driver class [com.ibm.as400.access.AS400Driver]

initializedDriverDataSource: as400 java.lang.IllegalStateException: Could not load JDBC driver class [com.ibm.as400.access.AS400Driver]

No Driver Found