nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

General approach for data deploy

ShovelFace

I am looking to push EA's (with replicants in some instances) to an Oracle database. The anticipated approach is to use User-Defined Schemas. Additionally, the content of the DCR itself will be deployed using OpenDeploy (with OpenDeploy and DataDeploy synchronized). Is this the recommended approach? Some general guidance would be appreciated.

SF

Find more posts tagged with

Comments

Migrateduser

Your approach sounds good. The documentation should be able to guide you though this.

Mariam

Migrateduser

SF,

What you described is a very typical approach and should work just fine. Then again, Mariam knows this better than anyone here but I'm just throwing in my $0.02.

Dave

ShovelFace

Thanks for the vote of confidence. In terms of synchronizing/rolling back the OpenDeploy/DataDeploy deployments, how hard is it to do that?

Migrateduser

Not at all. Generally, you should have a wrapper script that calls OpenDeploy. The OpenDeploy configuration calls another script as a DNR. This DNR script is a wrapper script that invokes DataDeploy. Based on your DataDeploy results, you can return nothing from the DD wrapper script which indicates a success or return the string below which causes OpenDeploy to back out of its deployment:

<response code="-2"/>\n

That's pretty much it. There is a trifle of documentation about this feature but not enough IMO.

Dave

Adam Stoller

Not at all. Generally, you should have a wrapper script that calls OpenDeploy. The OpenDeploy configuration calls another script as a DNR. This DNR script is a wrapper script that invokes DataDeploy. Based on your DataDeploy results, you can return nothing from the DD wrapper script which indicates a success or return the string below which causes OpenDeploy to back out of its deployment:

<response code="-2"/>\n

That's pretty much it. There is a trifle of documentation about this feature but not enough IMO.

Dave

I believe you also need to make the deployment transactional - if it isn't transactional, there is no rollback performed.

Migrateduser

*sigh* yes, that's correct. Leave it to Adam, Jeff or Andy to point out a reeeeally small omission like that.

jkepler

There are some gotchas with a user defined schema. You should watch out for deletions and rollback from the DB.

If a datadeploy job fails and you send a "-2" response code back from your wrapper script, OD will roll back the filesystem deploy. But, if the failure was with the 4th record you datadeployed, the 3 records that have already deployed will not be rolled back. That's a bummer. Your best solution here is good reporting so you know what is going on.

Also you will need to do some thinking if you want DD to delete records from the DB at the same time as deleting some resource from the filesystem. You will have to either pass a filelist to DD to delete/add/update a record, or update some sort of expiration time to invalidate a record.

We had this problem with synchronizing OD deployed content and database records. We thought that there should be a way to datadeploy an area that would figure out what we needed to delete, like an OpenDeploy remote comparison. But that was wishful thinking. DD will insert and update if you deploy an area, but not delete. You need to explicitly pass DD a filelist, or an individual file. If one of these files no longer exists on the source filesystem it will then delete it from the DB.

marcussteiner

If a datadeploy job fails and you send a "-2" response code back from your wrapper script, OD will roll back the filesystem deploy. But, if the failure was with the 4th record you datadeployed, the 3 records that have already deployed will not be rolled back. That's a bummer. Your best solution here is good reporting so you know what is going on.

Why should DataDeploy not rollback the 3 first records in your database in case of failure? There used to be a bug using CLOBs for Oracle -think in version 5.6- but other than that it will rollback your transaction and you'll have a database in the same state than before. If you expericence no rollbacks then describe the issue here.

M

Migrateduser

Are there any examples from the documentation of how to use data deploy to delete some data using the filelist deployment technique?

Bhargav Coca

You include this in your ddconfig.xml file.

[html]

[/html]

Thanks

Bill Klish

Why wouldn't you just use the dbLoader feature instead of writing this custom script you are referring to? I believe that dbLoader will rollback the full transaction if three is a problem with your content deployment or database deployment.