Adding a Database

To add a database using the Database Wizard, click the preferred database button in Desktop Designer Data tab ribbon > Step-by-step Database Wizard group.

There are three ways to start the Database Wizard:

• Option 1: Click the preferred database button in Desktop Designer Data tab ribbon > Step-by-step Database Wizard group.

• Option 2: Click the preferred database button in Dynamic Data Manager > Step-by-Step Database wizard ribbon group.

• Option 3: Click the +Database wizard command in Dynamic Data Explorer or object properties.

Listed below are the available wizard options. To successfully add a database, follow the steps for each database type:

• Adding an Excel database

• Adding an Access database

• Adding an SQL Server database

• Adding a Text File database

• Adding an Oracle database

• Adding a MySQL database

• Adding other OLE database

• Database Wizard for ODBC Data Sources

• Adding Google Sheets database

• Adding Excel (Microsoft OneDrive) database