ECDA 15.0 now provides a GUI wizard that performs certain setup and configuration tasks, depending on your platform.
ECDA Option for Oracle does not use ODBC drivers. However, it does require a unique set of configuration settings and a pointer to a file that will establish a connection to the target Oracle database. The Create Server wizard can easily create a DirectConnect™ server by asking for the required configuration properties and for a pointer to the appropriate file. Then, it applies the information to create and start a DirectConnect server.
In ECDA Option for Oracle, you can connect to the target
database without further configuration, as long as the settings
are correct. However, if necessary, you can still refine or correct
these settings by using DirectConnect Manager or by modifying them
with a text editor.
As of version 15.0, ECDA allows you to use multiple versions of an ODBC driver manager for Linux and UNIX platforms. ECDA ships with a default driver manager called unixODBC Driver Manager, but because you are no longer tied to a single type of driver manager, you can obtain a driver manager supplied by another vendor. However, to work properly with another vendor’s driver manager, the ECDA DirectConnect server needs an initial configuration to be able to link to the vendor driver manager you want. (If you provide none, it defaults to the unixODBC Driver Manager.)
To help you implement a vendor’s driver manager, ECDA 15.0 provides a Create Server wizard. Although the wizard does not complete the setup, it does simplify the process of getting the DirectConnect server configured to run with the driver manager that you specify. Then, when the DirectConnect server is running, you can use DirectConnect Manager to complete the configuration and further refine the settings of the services. Continuing with DirectConnect Manager, you can test the connections to the target database to validate those settings.
For Microsoft Windows products, ECDA will only use the driver manager that the operating system provides. The Create Server wizard will allow you to create a new server but it will not give you the ability to set up an alternative driver manager. (In this case, using the AddServer batch file may be a faster and easier approach.)
For Linux, UNIX, and Windows platforms, the Create Server wizard does not allow you to:
Create DSNs
Modify the odbc.ini file for a specific ODBC driver
Enable the connection to a target database
Refer to the vendor driver manager for utilities you can use to complete these tasks.
