Datadeploy beginner

I want to deploy the contents of a DCR to a Database table thru datadeploy. What are the configuration files i need to create and where do I put them? I've a DCT with 3 fields 2 text boxes and a browse button.
Any help is greately appreciated....
Thanks..

Find more posts tagged with

Comments

Migrateduser

If you want to deploy a DCR/XML to a database you need to follow these steps:
1. Create a database mapping a.k.a dbschema based on your datacapture file for the DCR or the DTD in case of a generic XML file. You can use either DDUI or CLT iwsyncdb.ipl -dbschemagen option to generate the database mapping
using CLT :
iwsyncdb.ipl -dbschemagen -dcfile <path_to_datacapture> [-deployAll]
or
iwsyncdb.ipl -dbschemagen -dtdfile <path_to_dtd> [-deployAll]

2. The above step creates a dbschema.cfg file with table mappings. Modify this file if necessary to suit your needs, i.e change datatypes etc...

3. Create a DataDeploy configuration file. Use the DDUI to generate this or use the attached dd config file and replace the section in <dbschema> with yours obtained from step2.
Modify the database sections to choose the appropriate database.

4. Run the deployment using iwdd.ipl cfg=mydep.cfg deployment=mydep or use the DDUI to run the deployment

Migrateduser

Sorry forgot the attachment

GodBlessMe

I want to deploy from a workflow.After i create a DCR, i want to attach it to the workflow and when it is approved, i want to deploy it to database. Is there any way Datadeploy can be configured so that even there are more than one DCR in the data folder, i deploy only the DCRs i want?
Thanks a lot...

Migrateduser

You might want to check the WorkFlow documentation about how to invoke an external task and invoke DD using iwdd.ipl command.
DD admin manual illustrates how to invoke a single file, directory or a list of files provided in a filelist.

StreamInParamter.png

Migrateduser

I went to try your command:

iwsyncdb.ipl -dbschemagen -dcfile <path to dct>

My version of iwsyncdb.ipl does not have a -dcfile flag. I was able to run it with the path to my workarea and then specify a specific category/type to generate. However, the dbschema file generated is not a complete deployment by itself, but an xml file that has group, attrmap, and keys elements.

Is this feature from a newer version of DD?

DD 5.5.2 Build 11360 on AIX

-------------------------------
E-Mail : farnsaw@stonedoor.com

Edited by farnsaw on 03/06/03 07:49 AM (server time).

Migrateduser

the -dcfile and -dtdfile options are only available since DD5.6 release. Once you have your table mappings in dbschema.cfg you need to create a dd config file using the ui or manually and use the mappings created earlier.