Versions Compared

Old Version 8

changes.mady.by.user Bülent Yüksel

Saved on

compared with

New Version Current

changes.mady.by.user Selahattin Bostanci

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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:

...

  • Source field : Select a field name from first table to relate from.
  • Target field : Select a field name for second table to relate to.

Initial Data

For some purposes, for example testing, you can populate tables with initial data entered in XML format. 

Code Block
languagexml
titleSample Data
<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

...

Add New Schema

...

 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.