You must prepare a database to function as the new system database before you perform the provisional installation of Hybrid Data Pipeline. The database requirements depend on the database you will be using.

Microsoft Azure SQL Database and SQL Server

If you plan on migrating to an external Microsoft Azure SQL Database or SQL Server database, you must take the following steps when setting up the database.

  1. Create a database schema to be used for storing Hybrid Data Pipeline system information.
  2. Create an administrator who can access the newly created schema. The administrator must have the CREATE TABLE privileges.
  3. Create a user who can access the newly created schema. The user must have the CREATE SESSION privileges.

After the database has been setup, you must provide the following information during installation:

  • Hostname (server name or IP address)
  • Port information for the database. The default is 1433.
  • Database Name
  • Schema Name
  • Administrator and user account information
    • An administrator name and password. The administrator must have the CREATE TABLE privileges.
    • A user name and password for a standard account. The user must have the CREATE SESSION privileges.

PostgreSQL

If you plan on migrating to an external PostgreSQL database, you must take the following steps when setting up the database.

  1. Enable the citext PostgreSQL extension.
  2. Create a database schema to be used for storing Hybrid Data Pipeline system information.
  3. Create an administrator who can access the newly created schema. The administrator must have privileges to create tables.
  4. Create a user who can access the newly created schema. The user must have privileges to select, insert, update, delete, and sequence tables.

After the PostgreSQL database has been setup, you must provide the following information during installation:

  • Hostname (server name or IP address)
  • Port information for the database. The default is 5432.
  • Database Name
  • Administrator and user account information
    • An administrator name and password. The administrator must have privileges to create tables.
    • A user name and password for a standard account. The user must have privileges to select, insert, update, delete, and sequence tables.