Currently DataSiphon is only available as a source tarball. This should change in the near future, but for now, you’ll need the following to run DataSiphon:
Once you have the prerequisites installed, simply untar the source and you‘re ready to go. DataSiphon can run in a self-contained directory without any additional installation.
If you want to work on DataSiphon, specifically the user interface, you’ll also need wxDesigner to read the wdr files. While wxDesigner is a very nice tool for people just learning the wxWindows/wxPython widget set, it is commercial, and I’ll be moving to a straight XRC-based schema soon.
The command line interface is named ds.py
. You can execute ds.py --help
at the command line to get a list of parameters. The syntax for the command line is:
ds.py [options] --source=<> --dest=<>
The options are briefly summarized here (this is the same help screen that you will get at the command line):
--source=
--dest= specify the source or destination provider; for example:
--source=<provider>:<optname>=<optvalue,...
--help-providers
list valid datasource providers
--help-options=<provider>
list the options, descriptions, and default values for a provider
--dest-mode=[i|u]
insert or update rows into the destination (default: insert)
--create-table create the table in the database
--typefile type definition file
--test run in test mode (generate SQL, no database calls)