My Oracle Support Banner

GoldenGate For BigData, Target Google BigQuery Table Getting Created With Schema Name (Doc ID 2594647.1)

Last updated on OCTOBER 22, 2019

Applies to:

Oracle GoldenGate Application Adapters - Version 12.3 and later
Information in this document applies to any platform.

Goal

Ct was trying to enable data replication from Oracle database to Google BigQuery, using Oracle GoldenGate for Big Data. They had following observed.

GG version: 12.3.2.1.1

Target side Big query table is getting created with the schema name appended with the table name.

For e.g., for the below table, target table is getting created with the name "sap_ecc_MARD_NEW"

MAP "PRODUSER"."MARD", TARGET "sap_ecc"."MARD_NEW";

A table with the same name exist in the Biquery dataset and its not getting used. Golden Gate is creating a new table instead, with the schema name appended.
 

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.