Creating New Workbook

Creating New Workbook

DBEdit uses a single connection string per workbook created with a workbook.

Later, you may change the data provider and database credentials. However, you cannot change the server platform, i.e., change SQL Server to Oracle Database.

To create a new workbook, click File, New or press Ctrl-N.

Step 1. Select Provider

In the first step, select a provider.

DBEdit shows all installed and supported providers. You may have fewer providers than shown.

Step 2. Connect to Database

In this step, specify database credentials.

Different database servers have specific features. Click the Help button or the Examples link to get the context help.

DBEdit checks the connection in the background and enables the Next button if succeeded.

If the Next button is disabled, click the Test Connection button to test the connection and update the state.

Step 3. Select Database Object

In this step, select an object to get data.

DBEdit supports tables, views, stored procedures, functions, and configured objects (of the CODE type).

You may filter objects by schemas:

Database developers can extend this drop-down list creating query lists to select objects by business areas.

Also, you may filter objects by names:

Step 4. Configure Fields and Parameters

In this step, for database tables and views, you may choose fields to select, in the leftmost column:

Also, you may choose fields to use as WHERE filters, in the rightmost column:

For stored procedures, functions, and SQL-based objects, the wizard allows customizing parameters only, but not select fields.

Step 5. New Workbook

When you click Finish in the previous step, DBEdit creates a new workbook with a connected worksheet like this:

You may add additional worksheets clicking the plus button in the tab list, or pressing Shift-F11, or using the Data, Insert Worksheet menu button.

This website is using cookies. By continuing to browse, you give us your consent to our use of cookies as explained in our Cookie Policy.