Regarding DataDeploy using workflow

Hi,

I need some information regarding the dataDeploy using workflow. First the workflow will be initiated then the attached files will be deployed to the target environment using OpenDeploy, then I have to invoke the DataDeploy command from the OpenDeploy to read the DCR's and insert it into the database table.

Any ideas.

Thanks.

Find more posts tagged with

Comments

Adam Stoller

Hi,

I need some information regarding the dataDeploy using workflow. First the workflow will be initiated then the attached files will be deployed to the target environment using OpenDeploy, then I have to invoke the DataDeploy command from the OpenDeploy to read the DCR's and insert it into the database table.

Any ideas.

Thanks.

What kind of ideas are you looking for?

You seem to have the process reasonably well understood. OD can invoke DD either through the dbLoader element or a DNR script run on the source-side of the setup. In general, if you do both OD and DD together like that - you want the deployment to be transactional (which means you need to make sure you have sufficient space on the target machine for 3 copies of every file that you deploy there; and that the overall deployment process will likely take a bit longer to complete)

That's all I can think of off the top of my head - if you have specific questions, ask them - but provide sufficient background / detail information in your questions to get the best responses (including product versions, platforms, etc.)

kshitiz

There are two options:

1. As suggested by ghoti, you can invoke a script through DNR in your OD configuration.
2. You can have two external tasks in your workflow: one for your OD and one for your DD. The drawback in this kind of approach is that it won't be transactional.

What is your specific requirement?

Dasari

Hi kshitiz,

According to your points, I have a query.

1. If we are invoking the datadeploy from openDeploy, openDeploy will invoke first ie. the attached files will be deployed to the target environment first and then we are invoking the datadeploy command. If there is any failure occurred while invoking the datadeploy and we are not stoping the opendeploy command. Then how it is going to be a transaction in the first scenario which you have mentioned.

2. According to the second scenario I have already added two external tasks, one for openDeploy to the target environment and other for the dataDeploy. If there is any failure occurred in the openDeploy then I am not invoking the dataDeploy external task and once openDeploy was successful then only I am invoking the dataDeoploy. If there is any failured occurred in the dataDeploy external task again I am invoking this external task.

3. I have created one dataDeploy configuration file, in that if I mentioned 'path name="templatedata/pages/" visit-directory="deep" ' under the 'source' element, will it retrieve all the DCRs under the pages directory and store it in a database?

Here my query is, if I attached only 10 files to the workflow from different folders under pages directory. I want to deploy those files which are attached to the workflow.ie.. I want to run the dataDeploy command for those attached files only, not for the other files?

Is there any possiblity?

Adam Stoller

Hi kshitiz,

According to your points, I have a query.

1. If we are invoking the datadeploy from openDeploy, openDeploy will invoke first ie. the attached files will be deployed to the target environment first and then we are invoking the datadeploy command. If there is any failure occurred while invoking the datadeploy and we are not stoping the opendeploy command. Then how it is going to be a transaction in the first scenario which you have mentioned.

If your OD deployment configuration is set to be transactional, and DD is called via a DNR script (before or after the actual file deployment process) - the script you wrap around DD to perform that deployment can return the standard XML snippet to STDOUT to indicate failure. If it does so, then OD will go into "rollback" mode - which means if you deployed the file assets first and then did the DD - the file assets would be restored to their pre-deployment status.

I believe the same functionality can be achieved using the dbLoader element - but I've never used it and so wont comment on it.

2. According to the second scenario I have already added two external tasks, one for openDeploy to the target environment and other for the dataDeploy. If there is any failure occurred in the openDeploy then I am not invoking the dataDeploy external task and once openDeploy was successful then only I am invoking the dataDeoploy. If there is any failured occurred in the dataDeploy external task again I am invoking this external task.

What is "this external task." that you mention at the end? Your own form of rollback deployment process? Using a transactional deployment process with DNR scripts (or dbLoader?) tends to be far more reliable.

3. I have created one dataDeploy configuration file, in that if I mentioned 'path name="templatedata/pages/" visit-directory="deep" ' under the 'source' element, will it retrieve all the DCRs under the pages directory and store it in a database?

I believe that's the idea - though I'll defer to someone with more DD experience.

Here my query is, if I attached only 10 files to the workflow from different folders under pages directory. I want to deploy those files which are attached to the workflow.ie.. I want to run the dataDeploy command for those attached files only, not for the other files?
Is there any possiblity?

Yeah - that's called a filelist deployment. Both OD and DD have filelist deployments - read the manual and you should be set to go.

Adam Stoller

Hi kshitiz,

According to your points, I have a query.

1. If we are invoking the datadeploy from openDeploy, openDeploy will invoke first ie. the attached files will be deployed to the target environment first and then we are invoking the datadeploy command. If there is any failure occurred while invoking the datadeploy and we are not stoping the opendeploy command. Then how it is going to be a transaction in the first scenario which you have mentioned.

2. According to the second scenario I have already added two external tasks, one for openDeploy to the target environment and other for the dataDeploy. If there is any failure occurred in the openDeploy then I am not invoking the dataDeploy external task and once openDeploy was successful then only I am invoking the dataDeoploy. If there is any failured occurred in the dataDeploy external task again I am invoking this external task.

3. I have created one dataDeploy configuration file, in that if I mentioned 'path name="templatedata/pages/" visit-directory="deep" ' under the 'source' element, will it retrieve all the DCRs under the pages directory and store it in a database?

I believe that's the idea - though I'll defer to someone with more DD experience.

Here my query is, if I attached only 10 files to the workflow from different folders under pages directory. I want to deploy those files which are attached to the workflow.ie.. I want to run the dataDeploy command for those attached files only, not for the other files?
Is there any possiblity?

Yeah - that's called a filelist deployment. Both OD and DD have filelist deployments - read the manual and you should be set to go.

Vishakha

For filelist deployment through datadeploy refer the below thread:
http://devnet.interwoven.com/forums_vb/showthread.php?t=17003&forumid=12