5 Connections

Learn about the connection types that Oracle Data Transforms supports and how to work with connections. This section also includes topics that cover 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 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 configured external storage.
• 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 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
  Data Transforms uses the Oracle NetSuite JDBC Driver 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 for uploading 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.