5 Connections

Learn about the connection types that Oracle Data Transforms supports and how to work with connections. You can also get instructions that are specific to certain connections.

Topics

• Work with Connections
  Connections help you to connect Data Transforms to various technologies reachable from your OCI network.
• Supported Connection Types
  This topic lists the connection types that are supported for connecting to Data Transforms.
• Create Custom Connectors
  The Custom Connections page of the Administration tab of Oracle Data Transforms helps you to create custom connectors that point to any JDBC supported data sources.
• Create a Data Transforms Connection for Remote Data Load
  You can connect to an existing Data Transforms instance and run a data load remotely.
• Create a Delta Share Connection
  Databricks Delta Share is an open protocol for secure data sharing. Oracle Data Transforms integrates with Delta Share to load data to Oracle Autonomous Database. You can use the Delta Share connection to load data from Databricks or Oracle Data Share.
• Create an Oracle Business Intelligence Cloud Connector Connection
  Oracle Business Intelligence Cloud Connector (BICC) allows you to extract business data from a data source and load it into Autonomous Database.
• Create and use an Oracle Cloud Infrastructure Generative AI Connection
  Oracle Cloud Infrastructure (OCI) Generative AI enables organizations to automate text summarization and dynamic content generation. Data Transforms integrates with OCI Generative AI to support the use of embedding vectors in a data flow.
• Create an Oracle Financials Cloud Connection
  You can fetch real time transactional data from Oracle Financials Cloud REST endpoints, import the data entities into Data Transforms, and use them as a source in a data flow.
• Create and Use an Oracle NetSuite Connection
  You can use the Oracle NetSuite JDBC Driver or OAuth 2.0 authentication to connect to the Oracle NetSuite application. For Oracle NetSuite connections, Data Transforms allows you to load pre-built dataflows and workflows that you can run to transfer data from NetSuite to your target schema.
• Create an Oracle Object Storage Connection
  You can use Data Transforms to upload data from Oracle Object Storage to Autonomous Database.
• Create a REST Server Connection
  You can connect to any REST service endpoint, import the data entities into Data Transforms, and use them as source in a data flow.