We use tracking cookies to understand how you use the product and help us improve it. Please accept cookies to help us improve. You can always opt out later via the link in the footer.
kind: source
spec:
name: oracledb
path: cloudquery/oracledb
registry: cloudquery
version: "v4.7.26"
tables: ["*"]
destinations: ["postgresql"]
# Learn more about the configuration options at https://cql.ink/oracledb_source
spec:
# A URL-encoded connection string used when connecting to the database in the format oracle://user:password@server:port/service_name.
# If choosing this method, make sure that special characters like `#`, `%`, `"`, etc., are correctly URL encoded.
#
# It’s generally recommended to use the `dsn` connection method instead of `connection_string`, as it
# helps avoid encoding errors by managing components separately.
#
# Note: To use the default port (1521), omit the port number from the connection string, but keep the
# colon (:), for example: oracle://user:password@server:/service_name.
# For more details, refer to the [Go driver documentation](https://github.com/sijms/go-ora).
connection_string: "${ORACLE_DB_CONNECTION_STRING}"
# Optional parameters
# dsn:
# server: 127.0.0.1
# port: 1521
# user: system
# password: ${ORACLE_DB_PASSWORD}
# service: xe
# options:
# trace file: oracle-trace.txt
# session_parameters:
# <SESSION_KEY>: "<VALUE>"
# queries: []
# rows_per_record: 500
# concurrency: 100
connection_string
(string
) (required if dsn
is not set)oracle://{user}:{password}@{server}:{port}/{service_name}
.
If the connection string contains special characters, those symbols must be encoded. It's generally recommended to use the dsn
instead of connection_string
, as it helps to avoid encoding errors by managing components separately.queries
(list of queries Spec) (optional)tables
in top-level spec should be left as *
or can be a subset of these tables.rows_per_record
(integer
) (optional) (default: 500
)concurrency
(integer
) (optional) (default: 100
)session_parameters
(map[string]string
) (optional)ALTER SESSION
command.server
(string
) (required)port
(int
) (optional, default: 1521
)service
(string
) (optional)xe
(for express), enterprise
, standard
, etc.user
(string
) (required)password
(string
) (optional)options
(map[string]string
) (optional)name
(string
) (required)query
(string
) (required)ALL_TABLES
meta table to the destination, as all_oracle_tables
table:kind: source
spec:
name: oracledb
path: cloudquery/oracledb
registry: cloudquery
version: "v4.7.26"
tables: ["*"] # We want all tables specified in queries to be synced
destinations: ["postgresql"]
spec:
# Connection string to connect to the database in the format oracle://user:password@server:port/service_name.
# To use the default 1521 port, you can omit it from the connection string, but still need to keep the :, for example oracle://user:password@server:/service_name.
connection_string: "${ORACLE_DB_CONNECTION_STRING}"
queries:
- name: all_oracle_tables
query: SELECT * FROM ALL_TABLES