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:

Vendor homepathC:\app\product\12.1.0\client_1
Databasemain_db
OS authenticationNo
Authentication modeNormal
CharsetWE8MSWIN1252
Application nameExportizer Enterprise 8
User namedexter
Password********
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:

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.

If selected data source is a multi-table database (for example, ODBC DSN, Microsoft Access database (.MDB, .ACCDB), Microsoft Excel sheet (.XLS, .XLSX), Oracle database, SQL Server database, etc.), then only Exportizer Pro and/or Exportizer Enterprise can open it.

See also

 Ways of Opening Different Data Source Types

 Connection Strings Examples