Exportizer Interfaces to Open Databases
Using Register Database dialog
Use Select Data Source button or the corresponding item from the File menu. In this dialog, you choose all parameters you need to open the database, and register the database for future use.
Example of configuring an Oracle database connection using FD interface:
|Application name||Exportizer Enterprise 8|
|SQL command separator||<sqlplus>|
Opening files directly from Windows Explorer
Some files (for example, DB, DBF etc.) can be opened by using file associations. If such a file is associated with Exportizer, then it is enough to click it twice and Windows will automatically start the associated application, and it will open the selected file.
Also, you can drag files from Explorer and drop them into the open instance of Exportizer.
Opening databases from command line
Almost all supported database types can be opened from the command line.
Opening files, which are not database files
Besides databases, Exportizer Pro and Exportizer Enterprise can also open some other file types:
- Action files. These files can be opened and executed using the corresponding tab of Register Database dialog or from the command line.
- SQL files. When opening a SQL file, the application firstly checks for presence of data files (like .dbf, .csv etc) in a folder, which contains the file. If such files are found, it opens that folder as a database (see above), then loads text of the file into SQL editor. If the data files are absent there, Exportizer Pro and Exportizer Enterprise lets you select associated database through Register Database dialog (see above). Anyway, in Exportizer Pro and Exportizer Enterprise, you can load SQL files after opening database using the corresponding buttons.
- Other files. When opening files of other types, Exportizer in most cases will try to open them like it does for database files (see above).
Reopening previously opened databases
The most recently used (MRU) databases can be accessed from File | Reopen or File | Registered Databases... menu, and can be easily reopened from there.
Another way to open a recently opened database is to select it from a drop-down list of Open Data Source button .
Some databases require password to be open. You can optionally save the password after successful database opening to avoid typing the password in the future. All saved passwords can be removed by choosing File | Registered Databases... | Clear Passwords.
After opening (connecting) the specified data source (database), you can choose dataset(s) to open.
If you open a database file which is a database table (for example, dBase (.DBF) file, file of comma separated values (.CSV) etc.), Exportizer will open its folder as a database and then open that database file as a table.