Follow these steps
to develop a job that runs on a DataFlux Data Management Server and
accesses a database:
-
Install the DataFlux
ODBC drivers (unless they were installed initially) on both the Data Management Studio client and on the DataFlux Data Management
Server. Use the regular installers as needed. DataFlux provides a number of wire-protocol drivers that enable you to connect
to specific databases without using a client-side library.
-
Create a
DSN on the database server.
-
Configure an ODBC client-side connection on the DataFlux Data Management Studio host using the
ODBC
Connections window in Studio, as described in the
Data
Management Studio User's Guide.
-
Create and test the job in DataFlux Data Management Studio. The nodes in the job will access the ODBC connection.
-
Upload the job from
Studio to the Data Management Server.
-
Either copy the ODBC connection file onto the server or create the connection on the server. To create a server connection
in Windows, use the
ODBC
Data Source Administrator. If your server is running in
UNIX or Linux, use the
dbdfconf tool that
is provided with the DataFlux Data Management Server.
If DataFlux Data Management Studio and DataFlux Data Management Server are installed and running on the same (Windows) host,
then you will need to set up the ODBC DSN two times. Set up one DSN through ODBC Connections in Studio. For the DataFlux Data Management Server, set up the DSN again using the ODBC Data Source Administrator.