Creating Database Info

You can use Database Info activity to specify the Server URL (JDBC URL), Username and Password to access the database. Server URL points to a specific database on a specified database server. There is no standard for Server URL. Every JDBC driver uses a slightly different syntax. For example, a Server URL for a MySQL database using the com.mysql.jdbc driver might look like this:

jdbc:mysql://localhost/databaseName

Database Info uses database driver to connect to the specified Database Server.

Prerequisites

Ensure that you have created a Database Driver activity before creating Database Info Activity.

Steps to create Database Info

1. Go to Account and click Manage Objects.

2. Click ACCOUNTS > Database Info.
   
3. Click CREATE Database Info Accounts.
4. On Create Database Info window, enter the name and description of the new Database Source in the Name and Description textboxes respectively.
5. Select an existing JDBC database driver activity from the Select JDBC Driver drop-down list.
   
   To use a new JDBC database driver activity, click Create New. 
   

    

   For information on how to create a database driver activity, refer to Creating Database Driver.

   Click here to know the Server URL Pattern of Business Application Connectors.

6. Enter the Server URL. Click Help displayed adjacent to the Server URL text box to get help in defining the Server URL.