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 DataFlux 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
DataFlux Data Management Studio to DataFlux 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.