Oracle Plugin¶
The Oracle plugin mainly provides a JDBC driver to access Oracle databases via the JDBC relation
Activation¶
The plugin can be easily activated by adding the following section to the default-namespace.yml
plugins:
- flowman-oracle
Usage¶
In order to connect to a Oracle database, you need to specify a JDBC connection and use that one in a JDBC relation as follows:
# First specify a connection. This can be used by multiple JDBC relations
connections:
frontend:
kind: jdbc
driver: "oracle.jdbc.OracleDriver"
url: "jdbc:oracle:thin:@my-oracle-server.domain.com/my-database"
username: "my_username"
password: "secret!password"
relations:
frontend_users:
kind: jdbcTable
# Specify the name of the connection to use
connection: frontend
# Specify the table
table: "users"
Data Types¶
Flowman will map its built in data types to the following data types in MariaDB
Flowman/Spark Datatype | MariaDB Datatype |
---|---|
string , text |
NVARCHAR2(255) |
binary |
BLOB |
tinyint , byte |
NUMBER(3) |
smallint , short |
NUMBER(5) |
int , integer |
NUMBER(10) |
bigint , long |
NUMBER(19) |
boolean , bool |
NUMBER(1) |
float |
BINARY_FLOAT |
double |
BINARY_DOUBLE |
decimal(a,b) |
DECIMAL(a,b) |
varchar(n) |
NVARCHAR2(n) |
char(n) |
NCHAR(n) |
date |
DATE |
timestamp |
TIMESTAMP |
duration |
unsupported |