When you open a process design page and then click on Databases, you will see a list of all relational database schemas tied to that process. If there is no schema yet you can simply click Import and add one of the existing schemas or click Add New Schema button to create a schema and its tables. All of the schema import, update and add operations are not executed until the process graph is changes are committed.
Import
...
Add New Schema
In order to add a new schema you have to enter a name and a prefix.
Clicking on Edit button unfolds a menu including:
...
For some purposes, for example testing, you can populate tables with initial data enterd entered in XML format.
Add New Schema
In order to add a new schema you have to enter a name and a prefix. The rest is same as described above
Code Block | ||||
---|---|---|---|---|
| ||||
<InitialData Language="">
<Properties />
<Columns>
<Column Name="Code" Type="System.String, mscorlib">
<Properties />
<Languages />
</Column>
<Column Name="Name" Type="System.String, mscorlib">
<Properties />
<Languages />
</Column>
<Column Name="Value" Type="System.Int32, mscorlib">
<Properties />
<Languages />
</Column>
</Columns>
<Rows>
<Row>
<Cells>
<Code Language=""><![CDATA[GB]]></Code>
<Name Language=""><![CDATA[Data Sample 1]]></Name>
<Value Language=""><![CDATA[122]]></Value>
</Cells>
<Tables />
</Row>
<Row>
<Cells>
<Code Language=""><![CDATA[KD]]></Code>
<Name Language=""><![CDATA[Data Sample 2]]></Name>
<Value Language=""><![CDATA[123]]></Value>
</Cells>
<Tables />
</Row>
<Row>
<Cells>
<Code Language=""><![CDATA[KK]]></Code>
<Name Language=""><![CDATA[Data Sample 3]]></Name>
<Value Language=""><![CDATA[124]]></Value>
</Cells>
<Tables />
</Row>
<Row>
<Cells>
<Code Language=""><![CDATA[TIK]]></Code>
<Name Language=""><![CDATA[Data Sample 4]]></Name>
<Value Language=""><![CDATA[125]]></Value>
</Cells>
<Tables />
</Row>
</Rows>
</InitialData> |
Import
Displays all existing schemas. Select the ones you want to include in your process and click Ok.