Skip Ribbon Commands
Skip to main content
SharePoint

Importing a Database Data Model

To simplify data model creation, you can create (or import) a data model based on the columns in a database table or view.

Note:
After importing the data model, any column changes made to the database table or view would also have to be made to the data model. The table/view and data model are not connected.

 
To import a Database data model, complete the following steps:
  1. Check out the solution.
     
  2. Click the Create tab. The Solution Items ribbon menu is displayed.
     
  3. Click the drop-down arrow below the New Data Model button. A drop-down list is displayed.
     
  4. Click Import Data Model from ODBC Resource. The Import Data Model window is displayed.
     
  5. Select a resource from the Select a ODBC System Resource drop-down list.
     
  6. Click Test Connection. A message will be displayed telling you whether the credentials worked successfully.
     
  7. Click Next. The Table and Column Selection tab is displayed.
     
  8. From the Select a Table or View drop-down list, select the table or view for which you want to create a data model.  Column names are displayed in the Database Name field.
     
  9. Select the columns you want to add to the imported data model, and click Next.
     
  10. Click Finish. You imported a database data model.
Related Topics
Creating a New Data Model
Adding Elements to a Data Model
Deleting a Data Model
Deleting an Element from a Data Model

Source
BPM Designer Topics > Overview of Solution Items and Solution Item Topics > Data Models
Last modified at 7/31/2020 11:37 AM