inserting Metadata into DB using Datadeploy

Hi,

We have to insert the Metadata values into Database using Datadeploy.If anyone done this type of experiment please share the experience.In the workflow, using cgitask we are invoking the metadata screen and once submitted the values has to be inserted into database using datadeploy. let me know the possible way to do this.

Thanks
Rathina

Find more posts tagged with

Comments

Michael

Hi

Inserting metadata into a database using DD is a common experiment.

You have many options -- many of which are discussed in the DD documentation.

What you implement depends on your individual circumstances. You will need to look at questions like:
- Do you have a predefined schema to deploy to?
- Is DAS an appropriate solution?
- Will the solutions OD-DD sync be appropriate?
- Do you have seperate database for TeamSite and your production web area?
- Is a direct connection from TeamSite to the database possible using DD or do you need to use the encryption facilities of OD with DD generated XML dump files?

It is often helpful to have an experienced TeamSite consultant on-site if your requirements are in any way tricky.

HTH

Cheers
Michael

Migrateduser

There was a DevNet webcast on deploying XML data to a relational db, you might want to check it out:
http://devnet.interwoven.com/site.fcgi/webcasts/index.html#webcast-18

The Distribution forum is also a good place to look for tips.

lissa

Migrateduser

so sorry, cut and paste error- the link should be:
http://devnet.interwoven.com/site.fcgi/webcasts/index.html#webcast-11

lissa

Rathina

1. We have tried the DAS option to insert the values.
but the table name has created by its own.so we havent an idea to change the table name.is there is an way to specify the table name we want?

2.By using the iwsyncdb.ipl -mdcdbschemagen we can create dbschema.cfg and using iwsyncdb.ipl -mdcddgen its creating mdc_dd.cfg but there is no detailed explanation for how to use iwdd.ipl command for that.

Can anyone throw some more lights to attain this.

Thanks
Rathina

Migrateduser

You cant have customized table names in DAS OOTB. You would have to do lot of customizations to the DD config files.
Please refer to the new DD manual section on Standalone deployments.
Also please post DD issues on the Distribution forum.