This guide will show you the resources to learn the basics of using ODI.
Oracle Data Integrator on OCI Marketplace
Basics/Overview of ODI on Youtube
Manipulating Data from Object Storage to ADW using ODI
To read a file from a remote server, you must install an agent on that server so it can access the files. Install an agent on the server (details on how & why)
Note: Using an agent is not allowed with ODI Marketplace - in place of the agent you can create a VPN connection, whitelist the IP address of the compute node ODI is running on, and/or have FastConnect.
Note: Again, this is not an option when solely using ODI in the cloud - you need an on-prem license as well.
To connect to SQL Server, it needs the JDBC driver & JRE installed on the SQL Server.
- Download & install the JDBC driver for SQL Server:
Getting started with the JDBC Driver
Download & install the Java Runtime Environment for SQL Server connection
- Adding JDBC & JRE to the path where SQL Server runs:
Setting the JAVA_HOME variable in windows
- Connecting to SQL Server on ODI (extra documentation):
Knowledge modules for SQL Server on ODI
Connecting with the JDBC Driver
-
You can execute SSIS packages from SQL Server stored procedures
-
Salesforce connects via JDBC as well
This is the syntax for salesforce's JDBC connection under physical topology:
jdbc.weblogic:sforce//login.salesforce.com;[email protected];Password=password12345;SecurityToken=6gaFzpiuetpyubD6Yhadk;ljadDTlNKpX
- More information on the agent
Where to install the standalone agent
Differences between the agents