Create and manage metabase

Data Integrity Suite
Product
Spatial_Analytics
Data_Integration
Data_Enrichment
Data_Governance
Precisely_Data_Integrity_Suite
geo_addressing_1
Data_Observability
Data_Quality
dis_core_foundation
Services
Spatial Analytics
Data Integration
Data Enrichment
Data Governance
Geo Addressing
Data Observability
Data Quality
Core Foundation
ft:title
Data Integrity Suite
ft:locale
en-US
PublicationType
pt_product_guide
copyrightfirst
2000
copyrightlast
2025

Db2 for IBM i, Db2 for LUW, Oracle, and SQL Server JDBC data connections used for a replication project must be associated with a metabase.

Create Metabase

You can create a metabase when you are a creating a new pipeline if it is the first pipeline in the project that uses this particular source data connection. Additionally, you can create a metabase from the project level action menu.
  1. From the Integration > Continuous Replication tab, click the ellipsis from the global action menu and select Metabase.
  2. On the Metabase page, if a metabase is not present, click +New Metabase to add a new metabase.
  3. On the New Metabase page, specify the metabase properties depending on the connection type and click Create.

Upgrade Metabase

Occasionally, metabases need to be upgraded to ensure that the metabase version on the source system matches the installed version of the Data Integration on the runtime server. Upgrading ensures the latest tables, indexes, and other objects are installed on the metabase.
Warning: Upgrading recreates metabase indexes and procedures.
  1. Disable capture for all enabled tables in all data connections for the associated with the metabase.
  2. Stop the project, if not already stopped.
  3. Click Projects from the navigation menu and open the replication project associated with the metabase you want to upgrade.
  4. Select the metabase you want to upgrade and click More > Upgrade.
  5. The Upgrade Metabase window opens showing metabase details including the database server, data connection, the current metabase version, and the version to which the metabase needs to be upgraded.
  6. Specify user credentials for the connection type (Db2 for IBMi or Db2 for LUW or SQL Server).
    Note: For Oracle, the Oracle administrator user ID for the Oracle system displays. By default, this value is SYS and cannot be changed.
  7. Enter the password for the user. If the password is not valid you are prompted to enter a valid password and click Upgrade.

Delete Metabase

You can delete any metabase you created for a replication data connection. For example, you may want to make changes to a metabase, in which case you must delete it and add another to the data connection.

When you delete a metabase, tables, procedures, and indexes are removed. The following also occurs based on the source connection type:
  • Db2 for IBMi - Tables are removed from the metabase library. The library, log files, and configuration files are not removed.
  • Db2 for LUW - The metabase schema and tablespace are removed.
  • Oracle - All tablespaces are dropped. The replication user, associated privileges, and schema are removed.
  • SQL Server - The data and log files are deleted. The replication user and associated privileges are removed.
    Note: The physical files associated with the metabase on the database system are not removed during this process. These files must be manually removed.
  1. Select the metabase you want to delete and click More > Delete. The Delete Metabase dialog opens, showing the metabase name, associated database server, and data connection.
  2. Specify user credentials depending on the connection type (Db2 for IBM I or Db2 for LUW or SQL Server).
    Note: For Oracle, the Oracle administrator user ID for the Oracle system displays. By default, this value is SYS and cannot be changed.
  3. Enter the user password for the user. If the password is not valid, you are prompted to enter a valid password and click Delete.
  4. Add another metabase as needed. You cannot start the project again without a metabase