Defining and Using a Database Connection Profile

A database connection profile defines a connection to a design-time target database for the database service call.

Using a database connection profile is entirely optional. Doing so can make it easier to define the database service task by enabling you to introspect the database to:

• use the SQL Query Editor to interactively build up and test a SQL query.
• automatically populate the database parameters on the Database tab.
• automatically generate a business object model class to hold the return value from your database call.
  Note: The design-time target database referenced by a database connection profile does not need to be the same as the runtime target database - you only select the runtime target database when you deploy your project. Indeed, security and/or access considerations may mean that you cannot use a database connection profile to connect to your runtime target database.

  However, if you do use a separate design-time target database - for example, one set up explicitly for development and/or testing purposes, it must use the same schema as the runtime target database