DataDeploy - create multiple rows?

rbuelling

We are trying to determine whether DataDeploy can fulfill our requirements for populating a database and we have the following question:

We are using a DCR that defines an article with multiple sections:

<record name="Article" type="content">
<item name="Title">
<value>Sample Article Title</value>
</item>
<item name="Section">
<value>Section1</value>
<value>Section2</value>
<value>Section3</value>
</item>
</record>

We would like to deploy this information to two tables:
1) Article table. Columns:
- Article ID (primary key)
- Title (from DCR)
2) Section table. Columns:
- Article ID (foreign key to article table)
- Section ID (primary key of section table)
- Section Name (from DCR)

With the sample DCR from above we would like DataDeploy to add one row to the article table and three rows to the section table (one row for each value in the DCR).

Is it possible to do that? If yes: where is the best place to look for documentation/examples for how to do that?

Thanks.

Ralph

Migrateduser

Yes DD can map the DCT to a set of RDBMS tables like your requirement. You can use the DDUI or CLT to map the DCT to a dbschema.cfg, this is documented in the new DD Manual.