Relational databases have well-structured schemas that declare every
element's data type. The following steps in Corticon Studio populate a new Vocabulary
from a relational database Datasource. For an example, use the Patient/Treatment schema
that was created in SQL Server from SQL statements in the Data Integration's ADC Connectivity sample.
To generate a Vocabulary from a relational data source:
In Corticon Studio, create a new Rules Project named GenMed.
In the new project, create a Vocabulary named GenMed.
Open the Vocabulary in its editor, and then select the menu
command Vocabulary > Add Datasource > Add ADC
Datasource.
Define the Datasource name as Patient Data. Connect
to SQL Server database PatientRecords. Enter credentials, and
the click CONNECTION Test:
Note: You might
want to add a Schema Filter value, such as dbo, to constrain the results of the next
step.
Click METADATA Import, and then choose the
option to choose the tables you want to use. For this example, choose just the two
dbo tables, as shown: and click Finish.
Select Vocabulary > Populate Vocabulary From
Datasource:
Choose the Patient Data Datasource. If there
were several Datasources defined, choose them one at a time for this process. In this
example, there is only one. Click Next.
A wizard opens to let you review the Datasource prior to creating the
Vocabulary elements, where you can select the Tables and Columns that create Entities
and Attributes. In the following image, the tree was expanded:
Click Finish. The Vocabulary is generated, as
shown:
Note: You might want to add a Schema Filter value, such as
