Skip Ribbon Commands
Skip to main content
SharePoint

Creating a Connection to a SQL Server Database

To create a connection to a SQL Server database that can be used by the Database Activities you need to create an ODBC System Resource.
 
The system resource supports ODBC-compliant databases. An ODBC system allows you to access data, regardless of the database management system, as long as the system supports ODBC.
   
To create a connection to a SQL Server Database, complete the following steps:
  1. Check out the solution.

  2. Click the Create tab. The Solution Items ribbon menu is displayed.

  3. Click New Resource. A drop-down list is displayed.

  4. Select ODBC System Resource. The ODBC System Resource window is displayed.

  5. In the ODBC System Resource name field, type a name for the new ODBC resource.

  6. In the Connection string field, click Edit.  The Data Link Properties window is displayed.
       
    Note:
    If you already know connection string, type the string into the field and proceed to step 13.

      
  7. Select Microsoft OLE DB Provider for SQL Server from the Provider tab.  
      
  8. Click Next. The Connection tab and corresponding screen are displayed.
     
  9. Select or type the server name in the Select or enter a server name field.
      
  10. Click either the Use Windows NT Integrated security or the Use Specific user name and password option.
     
    Note:
    If you want to save your credentials, select the Allow saving password check box. 
    If you do not want to save your credentials, select the Blank password check box.

      
  11. Select a database, from the Select the database on the server field.
      
    Note:
    Click Test Connection, if you want to ensure that BPM can access the selected database.

     
  12. Click OK.
          
  13. From the SQL Syntax drop-down list, select the syntax appropriate for your database management system.
      
  14. Click the save button. You created a connection to a SQL Server Database.
Related Topics
Database Activities
Creating a Connection to an Oracle Database
Deleting a System Resource

Source
BPM Designer Topics > Overview of Solution Items and Solution Item Topics > System Resources
Last modified at 7/31/2020 11:35 AM