How to connect from Dataflow to Oracle using TLS and JDBC with a wallet
Stay organized with collections
Save and categorize content based on your preferences.
Problem
Setting up a TLS connection from Dataflow to Oracle directly through configurable pipeline options is currently not supported.
Environment
- Cloud Dataflow
- Java SDK
- Oracle blog article available explaining how this is done from the Oracle perspective
Solution
- Upload the Oracle wallet files by using the --filesToStage option, which will add the files to the workers' class paths.
- With that information the JvmInitializer class can be used to set the relevant Java system properties.
Cause
In order to set up a TLS connection, Java system properties need to be configured in accordance with the Oracle blog article to point to wallet files located on worker machines. This is not supported out of the box for Dataflow right now.
Except as otherwise noted, the content of this page is licensed under the Creative Commons Attribution 4.0 License, and code samples are licensed under the Apache 2.0 License. For details, see the Google Developers Site Policies. Java is a registered trademark of Oracle and/or its affiliates.
Last updated 2024-12-12 UTC.
[[["Easy to understand","easyToUnderstand","thumb-up"],["Solved my problem","solvedMyProblem","thumb-up"],["Other","otherUp","thumb-up"]],[["Hard to understand","hardToUnderstand","thumb-down"],["Incorrect information or sample code","incorrectInformationOrSampleCode","thumb-down"],["Missing the information/samples I need","missingTheInformationSamplesINeed","thumb-down"],["Other","otherDown","thumb-down"]],["Last updated 2024-12-12 UTC."],[],[]]
