Creating a data development project

Before you create routines or other database development objects, create a data development project to store your objects. A data development project is linked to one database connection in the Data Source Explorer.

About this task

A data development project is used to store data application development artifacts. You can store and develop the following types of objects in a database development project:
  • Stored procedures
  • User-defined functions
  • Routine test configurations
  • SQL scripts
  • XML artifacts
  • Web services
You can also test, debug, export, and deploy these objects from a data development project. The wizards that are available in a data development project use the connection information that is specified for the project to help you develop objects that are targeted for that specific database.

Using the New Data Development Project wizard, you specify basic information about the project, including the name and default application settings such as default schema. You also specify which database connection to use for the project. You can use an existing connection or create a new connection.

Procedure

To create a data development project:

  1. On the main menu bar, click File > New > Project, then expand the Data node and click Data Development Project. If you do not see the Data node or the Data Development Project option, click Show All Wizards. The New Data Development Project wizard opens.
  2. On the first page of the wizard, specify a name for the project, and then click Next.
  3. On the second page of the wizard, specify a database connection to link to the project, and then click Next. You can select an existing connection from the list, or select Create new connection to create a new database connection. If you select the option to create a new connection then you must specify connection and filtering information on the next two pages of the wizard. If you choose to connect to a DB2® for z/OS® database, you must specify additional options in the wizard.
  4. On the final page of the wizard, specify the default values for the database manager to use when processing SQL statements.
  5. Click Finish. The data development project is displayed in the Data Project Explorer view.

Results

If the database connection that you specified for your project is deleted from the Data Source Explorer or becomes disconnected, you will be prompted to reconnect before you can create or modify objects in your data development project.

Feedback