ECDA 15.0 includes a GUI wizard that performs, depending on your platform, certain setup and configuration tasks.
The 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 establishes a connection to the target Oracle database. You can create a DirectConnect™ server by providing the required configuration properties, and a pointer to the appropriate file to the Create Server wizard. The wizard applies the information to create and start a DirectConnect server. As long as the settings are correct, you can connect to the target database without further configuration. However, if necessary, you can still refine or correct these settings by either 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 you can obtain a driver manager supplied by another vendor. However, to work properly with a driver manager from another vendor, the ECDA DirectConnect server needs an initial configuration. If you do not provide an initial configuration, the DirectConnect server defaults to the unixODBC Driver Manager.
To help you implement a particular vendor’s driver manager, ECDA 15.0 provides a Create Server wizard that simplifies configuring the DirectConnect server to run with the driver manager 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, and test the connections to the target database to validate those settings.
For Microsoft Windows products, ECDA uses only the driver manager that the operating system provides. You can use the Create Server wizard to create a new server but you cannot set up an alternative driver manager. Using the AddServer batch file may be a faster and easier approach.
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.
