Creating New Workbook

Creating New Workbook

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

Later, you can 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 Connection Wizard - Select Provider

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

Step 2. Connect to Database

In this step, specify database credentials.

DBEdit Connection Wizard - Reconnect to Database

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 Connection Wizard - Select Object

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

You can filter objects by schemas:

DBEdit Connection Wizard - Select Schema to Filter Objects

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

Also, you can filter objects by names:

DBEdit Connection Wizard - Filter Objects

Step 4. Configure Fields and Parameters

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

DBEdit Connection Wizard - Select Fields

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

DBEdit Connection Wizard - Select Where Fields

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:

DBEdit - New Workbook - View Sample

You can 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.OK