Prerequisites
Learn how to collect the information you need to deploy the Oracle CDC to Kudu ReadyFlow, and meet other prerequisites.
For your data ingest source
-
You have obtained the Oracle database server hostname and port.
-
You have obtained the Oracle database name , 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 Oracle table.
-
You have obtained the Oracle database driver jar file.
- You have performed the Oracle Server setup tasks required to run Debezium.
For DataFlow
-
You have enabled DataFlow for an environment.
For information on how to enable DataFlow for an environment, see Enabling DataFlow for an Environment.
-
You have created a Machine User to use as the CDP Workload User.
- You have given the CDP Workload User the
EnvironmentUser role.
- From the Management Console, go to the environment for which DataFlow is enabled.
- From the Actions drop down, click Manage Access.
- Identify the user you want to use as a Workload User.
- Give that user EnvironmentUser role.
-
You have synchronized your user to the CDP Public Cloud environment that you enabled for DataFlow.
For information on how to synchronize your user to FreeIPA, see Performing User Sync.
- You have granted your CDP user the
DFCatalogAdmin and DFFlowAdmin roles to
enable your user to add the ReadyFlow to the Catalog and deploy the flow definition.
- Give a user permission to add the ReadyFlow to the
Catalog.
- From the Management Console, click User Management.
- Enter the name of the user or group you wish to authorize in the Search field.
- Select the user or group from the list that displays.
- Click .
- From Update Roles, select DFCatalogAdmin and click Update.
- Give your user or group permission to deploy flow definitions.
- From the Management Console, click Environments to display the Environment List page.
- Select the environment to which you want your user or group to deploy flow definitions.
- Click Environment Access page. to display the
- Enter the name of your user or group you wish to authorize in the Search field.
- Select your user or group and click Update Roles.
- Select DFFlowAdmin from the list of roles.
- Click Update Roles.
- Give your user or group access to the Project where the ReadyFlow will be
deployed.
- Go to .
- Select the project where you want to manage access rights and click .
- Start typing the name of the user or group you want to add and select them from the list.
- Select the Resource Roles you want to grant.
- Click Update Roles.
- Click Synchronize Users.
- Give a user permission to add the ReadyFlow to the
Catalog.
For your data ingest target
-
You have a Real-Time Data Mart cluster running Kudu, Impala, and Hue in the same environment for which DataFlow has been enabled.
-
You have the Kudu Master hostnames.
- From Management Console, click Data Hub Clusters.
- Select the Real-Time Data Mart cluster to which you want to ingest data into.
- Click the Hardware tab.
- Copy the FQDN for each Kudu Master.
- You have the Kudu database name.
-
You have created the Kudu table that you want to ingest data into. Ensure that the field case sensitivity matches that of the source table.
- Navigate to your Real Time Data Mart cluster and click Hue from the Services pane.
- Click the Tables icon on the left pane.
- Select the default database, and click + New to create a new table.
- In the Type field, select Manually and click Next.
- Provide the table Name, Format, Primary keys, and any partitions.
- Click Submit. The newly created table displays in the default database Tables pane.
- Check the Kudu UI Tables tab for the name of the table you created. You will need this table name when you use the DataFlow Deployment wizard to deploy the ReadyFlow.
-
You have assigned permissions via IDBroker or in Ranger to enable the CDP Workload User to access the Kudu table that you want to ingest data into.
- From the base cluster on CDP Public Cloud, select Ranger.
- Select your Real Time Data Mart cluster from the Kudu folder.
- Click Add New Policy policy.
- On the Create Policy page, enter the Kudu table name in the topic field.
- Add the CDP Workload User in the Select User field.
- Add the Insert and Select permissions in the Permissions field.
- Click Save.