dtacheron/scdf repository overview

⁠SCDF (from pivotal) with Oracle Support

⁠Why

Pivotal doesn't publish scdf builds including Oracle drivers although Oracle database is supported by the product.
If you want to run SCDF on Oracle, documentation instructs us to rebuild the projet, and include the relevant jdbc driver.

⁠How

• git clone pivotal's github repository
• git checkout to relevant tag depending on targeted version
• modify pom.xml in order to add a dependency on oracle jdbc drive, like below :
  global pom.xml (root of multi-modules)

	<properties>
		<oracle.version>23.2.0.0</oracle.version>
    [..]
	<dependencyManagement>
		<dependencies>
			<dependency>
				<groupId>com.oracle.database.jdbc</groupId>
				<artifactId>ojdbc8</artifactId>
				<version>${oracle.version}</version>
			</dependency>

spring-cloud-dataflow-server module's pom.xml

	<dependencies>
		<!-- add oracle -->
		<dependency>
			<groupId>com.oracle.database.jdbc</groupId>	
			 <artifactId>ojdbc8</artifactId>
		</dependency>

• build jar and image

./mvnw -DskipTests install --projects spring-cloud-dataflow-server --also-make
./mvnw -DskipTests=true -projects spring-cloud-dataflow-server spring-boot:build-image

⁠Point of attention

You have to select relevant jdbc driver depending on your Oracle version.
https://docs.oracle.com/en/database/oracle/oracle-database/21/jjdbc/JDBC-getting-started.html#GUID-926E5324-D89A-4A00-B1AE-975C1089F0EA⁠
You have to select a thin (type 4) driver.
You have to select a driver for java 8 (scdf is builded on JDK 1.8).
Some oldies Oracle version are not supported by scdf (due to redgate flyway's community edition limitations).
https://documentation.red-gate.com/fd/supported-database-versions-143754067.html⁠
Presently (August 2023) It seems that you need at least an Oracle 19c version.