Prerequisites

Learn how to collect the information you need to deploy the PostgreSQL CDC to Iceberg [Technical Preview] ReadyFlow, and meet other prerequisites.

For your data ingest source

You have obtained the PostgreSQL database server hostname and port.
You have obtained the PostgreSQL schema name and table name. Take note of the table structure, specifically field case sensitivity.
You have obtained a username and password to access the PostgreSQL table.
You have performed the PostgreSQL setup tasks required to run Debezium.

For Cloudera DataFlow

You have enabled Cloudera DataFlow for an environment.

For information on how to enable Cloudera DataFlow for an environment, see Enabling Cloudera DataFlow for an Environment.
You have created a Machine User to use as the Cloudera Workload User.
You have given the Cloudera Workload User the EnvironmentUser role.
1. From the Management Console, go to the environment for which Cloudera DataFlow is enabled.
2. From the Actions drop down, click Manage Access.
3. Identify the user you want to use as a Workload User.
  note
  
  The Cloudera Workload User can be a machine user or your own user name. It is best practice to create a dedicated Machine user for this.
4. Give that user EnvironmentUser role.
You have synchronized your user to the Cloudera Public Cloud environment that you enabled for Cloudera DataFlow.

For information on how to synchronize your user to FreeIPA, see Performing User Sync.
You have granted your Cloudera user the DFCatalogAdmin and DFFlowAdmin roles to enable your user to add the ReadyFlow to the Catalog and deploy the flow definition.
1. Give a user permission to add the ReadyFlow to the Catalog.
  1. From the Management Console, click User Management.
  2. Enter the name of the user or group you wish to authorize in the Search field.
  3. Select the user or group from the list that displays.
  4. Click Roles > Update Roles.
  5. From Update Roles, select DFCatalogAdmin and click Update.
    note
    If the ReadyFlow is already in the Catalog, then you can give your user just the DFCatalogViewer role.
2. Give your user or group permission to deploy flow definitions.
  1. From the Management Console, click Environments to display the Environment List page.
  2. Select the environment to which you want your user or group to deploy flow definitions.
  3. Click Actions > Manage Access to display the Environment Access page.
  4. Enter the name of your user or group you wish to authorize in the Search field.
  5. Select your user or group and click Update Roles.
  6. Select DFFlowAdmin from the list of roles.
  7. Click Update Roles.
3. Give your user or group access to the Project where the ReadyFlow will be deployed.
  1. Go to DataFlow > Projects.
  2. Select the project where you want to manage access rights and click More > Manage Access.
4. Start typing the name of the user or group you want to add and select them from the list.
5. Select the Resource Roles you want to grant.
6. Click Update Roles.
7. Click Synchronize Users.

For your data ingest target

In Cloudera Data Warehouse, you have activated the same environment for which Cloudera DataFlow has been enabled. This will create a default database catalog. For more information, see Activating an AWS environment from Cloudera Data Warehouse or Activating Azure environments.
You have created a Hive Virtual Warehouse referencing the default database catalog. For more information, see Creating your first Virtual Warehouse.
You have created the Iceberg table that you want to ingest data into, running in your Hive Virtual Warehouse. For more information, see Iceberg table creation from Hive.