Allows connecting to Oracle database.
For the Oracle connection to work it is a requirement that the latest Oracle ODAC is installed on the machine.
Ensure the Oracle User Account has the Select Any Dictionary rights grated as shown below.
Enter the name of the data source
Name of the server hosting the Oracle database
Specify the port where Oracle is listening for connections. Default port is 1521.
Enter the Service Name for your Oracle connection.
Enter the User Id to logon to Oracle DBMS
Enter the password to logon to the Oracle DBMS
Click connect to establish the connection to Oracle
Choose the schema/database from which you want to retrieve the data
Choose the table to import data from
Enter a custom and valid SQL command that will select data from your Oracle database