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
Go to Account and click Manage Objects.
- Click ACCOUNTS > Database Info.
- Click CREATE Database Info Accounts.
- On Create Database Info window, enter the name and description of the new Database Source in the Name and Description textboxes respectively.
- 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.
- Enter the Server URL. Click Help displayed adjacent to the Server URL text box to get help in defining the Server URL.