Oracle Connect

Oracle data into your data warehouse in minutes

Collect Oracle data into your data warehouse or ours. The Matatika pipelines will take care of the data collection and preparation for your analytics and BI tools.

Automate Oracle from a single space with no code

Oracle is a multinational computer technology corporation that specializes in developing and marketing database software and technology, cloud engineered systems, and enterprise software products.

Oracle provides a wide range of software and services for businesses, including database management systems, cloud infrastructure, enterprise resource planning (ERP) software, customer relationship management (CRM) software, and supply chain management software. Their products are designed to help businesses manage their data, streamline their operations, and improve their overall efficiency and productivity. Oracle also offers consulting, training, and support services to help businesses get the most out of their software and technology investments.

Settings

Offset Value

The starting point for retrieving data from the Oracle API.

Password

The password for the user account used to connect to the Oracle API.

Filter Schemas

A list of schemas to filter data by when retrieving from the Oracle API.

Use Singer Decimal

A boolean value indicating whether to use Singer Decimal format for decimal values.

Filter Tables

A list of tables to filter data by when retrieving from the Oracle API.

Logminer Dynamic Scn Window

A boolean value indicating whether to use a dynamic SCN window for Logminer.

Common SID

The System ID (SID) for the Oracle database to connect to.

Common Service Name

The service name for the Oracle database to connect to.

Default Replication Method

The default method for replicating data from the Oracle API.

Logminer Call Timeout

The maximum time to wait for a Logminer call to complete.

Logminer Iter With Reduction Factor

The reduction factor to use when iterating through Logminer data.

Port

The port number to use when connecting to the Oracle API.

Common User

The user account to use when connecting to the Oracle API.

SID

The System ID (SID) for the Oracle database to connect to.

Scn Window Size

The size of the SCN window to use when retrieving data from the Oracle API.

Use Ora Rowscn

A boolean value indicating whether to use Oracle ROWSCN for change tracking.

Common Password

The password for the user account used to connect to the Oracle API.

Cursor Array Size

The size of the cursor array to use when retrieving data from the Oracle API.

Host

The hostname or IP address of the server running the Oracle API.

User

The user account to use when connecting to the Oracle API.

Service Name

The service name for the Oracle database to connect to.


View source code

Oracle data you can trust

Extract, Transform, and Load Oracle data into your data warehouse or ours.

Interested in learning more?

Get in touch