data deploy

hi all,
can anybody tell me how make a user defined database schema, and generate tables using it, through DAS or Datadeploy UI.

Thanking you in anticipation.

Find more posts tagged with

Comments

Migrateduser

To generate a dbschema you can use the CLT iwsyncdb.ipl -dbschemagen or use the UI to generate it.
Once you generate the dbschema you need to generate the ddconfig file using iwsyncdb.ipl -ddgen or DDUI and
register the initial tables for DAS using iwsyncdb.ipl -initial .... or UI

chandub

I am facing the same problem,
can you please eloborate on the ddconfig generation.

is there any iw technical documentation you can point me to.

suppose say i want to map my datacapture fields
role_id
rolename
to a table called as Role in the database.
how i can do this?

Right now iam following the below procedure with out luck
1) create a datacapture with the above fields in a category and save the data as a DCR.
2) Open the ddui and goto MAP DCT to dbschema
3) and fill all the appropriate fileds and connect to database
4)destination : newschema or exciting schema
5)update the DD-home/conf/ddcfg_uds.template with database information.
6) save the dbscehma in the corrresponding datatype
7)go to the DAS option and update the workarea and DCR type.
8) it is creating the book_dd.cfg in my Datatype folder.But still the table names look like defeult_wa_category_datatyp.
9) where are other table which i need to modify
you said ddconfig.cfg.... how do i generate this?
any tech notes please let me know i will give my email id to discuss on this.
thanks
chandra

Migrateduser

For more information you can look at Chapter 3 in the new DataDeploy Admin Guide (released last week). It is still called version 5.6, but it is completely new (part #90-25-00-560-300).
Chapter 3 "Configuring Deployments" contains descriptions of "Mapping Database Schemas" and "Creating the DD Config File" with both the administration UI and the CLTs.

Migrateduser

looks like you need to use standalone deployments. Since you want to deply your dcr data to a predefined table name.
If you want to do standalone deployments you can just run the clt iwdd.ipl cfg=yourdd.cfg deployment=deployment-name
or you could invoke the deployment using the DD UI from the standalone deployments section.
If you use DAS the table names are created by Datadeploy for Workarea and staging areas using a standard convention. You could use DAS to deploy to a predefined table by doing some customizations in your config files.

chandub

***************
You could use DAS to deploy to a predefined table by doing some customizations in your config files.
*****************
Which files need customization.
I would like to use the DAS option to store my DCRs in pre defined tables.(mapping to multiple tables from a same DCR)
If you have the sample config files already configured ,please send the same to chandra.bangari@wipro.com

TIA

Migrateduser

Is there a reason you dont want to use the tables generated by DataDeploy?
How do you want to update your database tables? i.e. Do you want your table to reflect data in your workarea or STAGING. If you want your table to be in sync with Staging then you might just implement a submit workflow which would kickoff a DataDeploy deployment. If its workarea then you may have to do lot more customizations such as turning off certain events from TeamSite, changing config files etc...