Creating a database connection profile

To generate a database application, you must have a database connection profile that provides information about the database that you want to use.

Create a connection profile

1. If the Create Application from Database dialog box is not already open, select Data > Create Application from Database.
2. Click the New button to the right of the Connection text box.
3. In the Create Connection Profile dialog box, enter a connection name in the Name text box. You can also complete the optional Description text box.
4. (Optional) When the wizard is finished or when the Data Source Explorer is opened, select the Autoconnect option to connect to the database.
5. Click New.
6. Complete the database connection text boxes. The fields vary depending on the type of database connection you choose. For PHP projects, you use MySQL. For ASP.NET projects, you use Microsoft SQL Server. For J2EE projects, you can select from a list of choices, but MySQL and Microsoft SQL Server are supported.
7. Click Test Connection to make sure that the connection is valid.
8. Click Next.
9. Click Finish.