You work for a rapidly growing data science organization. Your organization develops software products to analyze financials, building financial graphs connecting people profiles, companies, jobs, advertisers, and publishers. The organization uses infrastructure based on Google Cloud Platform and stores its data in various data sources such as Oracle. The organization plans to implement a business intelligence service to build visualization and perform real-time analysis. Therefore, you need to port the vast amount of changed data stored in the Oracle data source to Google BigQuery, which is a highly scalable, cost-effective and fully managed enterprise data warehouse on a regular interval of time. Use Google Analytics to run high-performance analytics.

You can use a PowerExchange Express CDC for Oracle real-time connection to read changed data from the Oracle database. To write this large amount of data, you can use the PowerExchange for Google BigQuery connection.

To write changed data to a Google BigQuery object, perform the following steps:

Import the PowerExchange Express CDC for Oracle source object in PowerCenter Designer and create a PowerExchange for Oracle CDC real-time source connection.
Create or import a Google BigQuery target object and create a PowerExchange for Google BigQuery connection.
Create a mapping.
Create a session and configure the session properties.
Run the session.