Add a Replicat for Databricks

Learn to add and configure a Replicat process for a Databricks target.

Related Topics

Before you begin

Before you add the Replicat, ensure that you have the following:

Add a Replicat (23ai)

To add a Replicat in GoldenGate:
  1. In the OCI GoldenGate deployment console, on the Administration Service Home page, click Add Replicat (plus icon).
  2. In the Add Replicat panel, on the Replicat Information page, complete the fields as needed, and then click Next:
    • For Replicat Type, select Classic Replicat.
    • Enter a Process Name, no more than 5 characters long.
    • Enter a Description, to help distinguish this process from others.
  3. On the Replicat Options page, complete the fields as needed, and then click Next:
    • For Name, enter the name of the Trail from Task 2.
    • For Target, select Databricks.
    • For Available Aliases, select your Databricks connection.
    • For Available Staging Location, select Azure Datalake Storage.
    • For via staging alias, select your Azure Datalake Storage connection.
  4. On the Managed Options page, leave the fields as is, and then click Next.
  5. On the Parameter File page, replace MAP *.*, TARGET *.*; with the following, and then click Next: 
    MAP SRC_OCIGGLL.SRC_CUSTOMER, TARGET <target_catalog_name>.<target_schema_name>.SRC_CUSTOMER
  6. On the Properties File page, configure the File Handler and OCI Event Handler properties as needed. Some properties to consider modifying include:
    1. Provide the target Azure Datalake Storage container name in gg.eventhandler.abs.bucketMappingTemplate.
    2. Add gg.handler.databricks.fileRollInterval=5s.

    For information on this target's properties, see Databricks in the Oracle GoldenGate for Distributed Applications and Analytics guide.

  7. Click Create and Run. If you click Create, then you can manually start the Replicat later from the Administration Service Home page.