webMethods and Intelligent Business Operations 10.2 | Designing and Implementing Composite Applications | webMethods CAF and OpenCAF Development Help | Views in the Composite Application Framework | Connecting to a Database
 
Connecting to a Database
To connect to a database in the Data Source Explorer view, do the following:
* To connect to a database in the Data Source Explorer
1. If the Data Source Explorer view is not visible:
Window > Show View > DataSource Explorer.
2. In the Data Source Explorer, click New Connection Profile.
3. In New Connection Profile page, select the Connection Profile Type and click Next.
4. In Specify Driver and Connection Details, from the Drivers list, select a driver, and then click Next.
5. In Select a driver from the dropdown, choose the appropriate database driver.
6. In the URL field, type the URL for the database, including the database name. For example:
jdbc:wm:sqlserver://localhost:1433;DatabaseName=Northwind
7. In the User Name field, type the valid user name for the database.
8. In the Password field, type the password.
9. Click Test Connection to test the connection to the database.
10. Click Finish.
11. Right-click the node, and click Connect.
Copyright © 2018 | Software AG, Darmstadt, Germany and/or Software AG USA, Inc., Reston, VA, USA, and/or its subsidiaries and/or its affiliates and/or their licensors.
Innovation Release