Use the interactive ODBC Configuration Tool (dfdbconf) to add new data sources to the ODBC configuration

1. From the root directory of the dfexec.cfg installation, run: ./bin/dfdbconf.
2. Select A. to add a data source. You can also use dfdbconf to delete a data source if it
is no longer needed.
3. Select a template for the new data source by choosing a number from the list of
available drivers.
4. You are prompted to set the appropriate parameters for that driver. The new data
source is then added to your odbc.ini file.

Once you have added all of your data sources, the interactive ODBC Viewer (dfdbview)
application can be used to test your connection. For example, if you added a data source
called my_oracle, run: ./bin/dfdbview my_oracle (from the installation root) to test the
connection. You may be prompted for a user name and password. If the connection
succeeds, you will see a prompt from which you can enter SQL commands and query the
database. If the connection fails, DIS displays error messages describing one or more
reasons for the failure.

Note: When configuring the new data source, it is critical that the
parameters (such as DSN, host, port, and sid) match exactly those used to
create the job on the client machine.


AccountString []:
AuthenticationDomain []:
AuthenticationPassword []:
AuthenticationUserid []:
CharacterSet [ASCII]:
ColumnSizeAsCharacter [1]:

Installaation :

./bin/dfdbconf
/apps/sas/dataflux/dfpower/etc

root@localhost # cd /apps/sas/dataflux/dfpower

root@localhost # ./bin/dfdbview DW_production

DataFlux ODBC Viewer

Please provide a user ID and password for 'DW_production'.

(Leave the fields blank to connect without a user ID or password.)

User ID:

DW_production is the DSN name