Creating DCR's from a external Store

One of our client has a primary content management system ABC and the secondary content system as Teamsite.

The primary content management system is used to manage some factual content such as fianancial content (secured, where only very few people have access to it). Once they complete their business process and set the status to publish, the shared content will written to a shared database.

The Secondary content management system (Teamsite), will have to invoke a nightly workflow, to query the database to get the content that is set to publish status and create DCR's based on the content in the shared database.

The questions i have is :

1. Is it feasible to create DCR's on the fly based on the content that is available?
2. Has any one earlier designed/implemented such a approach/ suggest some better ways to design and implement this would be great

Thanks
-santvs

Find more posts tagged with

Comments

Migrateduser

Adam Stoller

One of our client has a primary content management system ABC and the secondary content system as Teamsite.

The primary content management system is used to manage some factual content such as fianancial content (secured, where only very few people have access to it). Once they complete their business process and set the status to publish, the shared content will written to a shared database.

The Secondary content management system (Teamsite), will have to invoke a nightly workflow, to query the database to get the content that is set to publish status and create DCR's based on the content in the shared database.

The questions i have is :

1. Is it feasible to create DCR's on the fly based on the content that is available?
2. Has any one earlier designed/implemented such a approach/ suggest some better ways to design and implement this would be great

Thanks
-santvs

No need to ask twice :-)
Is it feasible - sure - it's often done for things like news feeds and such.
A lot depends on the format of the data you are retrieving from the primary system. If it's XML that conforms to an established DTD - you should be able to create a DCT based on that DTD, import the content directly into TeamSite and set EAs on it to establish it as a DCR.[indent]If you are retrieving actual files - just put the file into templatedata/category/data-type/data/..., if you are retrieving data, create the file in the aforementioned location - though you'll have to come up with a naming scheme for the files so that you can programmatically generated them.[/indent]If it's not in XML format, or does not conform to a DTD you need to do a bit more work - such as creating the DCT you want to use for the data, and then writing the DCR correctly using the data you're pulling in (I strongly advise using "xml" over "iwov" style DCRs). You still have to set the EAs on the file though.

Migrateduser

Thanks fish, I guess because of some session issue, i submitted the request twice. :-)

The required content is in a Shared oracle database and the DCT's are pre-defined. I guess we will have to extract them first to an xml format and then write the DCR's and then set the Extended attributes for the DCR.

Adam Stoller

Thanks fish, I guess because of some session issue, i submitted the request twice. :-)

The required content is in a Shared oracle database and the DCT's are pre-defined. I guess we will have to extract them first to an xml format and then write the DCR's and then set the Extended attributes for the DCR.

I'm assuming the data is in multiple columns in the DB - not just one big clob.
If you know the DCT structure it should be pretty easy to write a DBI (perl or java) to query the DB, retrieve the data and build the DCR programmatically (in an appropriate location with an appropriate filename) and then after building it the same script / program can run iwextattr (or CSSDK equivalent) to set the appropriate EA on the DCR.

Don't rush the design phase of this - figure out the format / structure of the data, figure out how to access it, figure out how to write it out, etc. - build little test scripts along the way so you can run them from the command line and verify that they work correctly - eventually you can combine the code from the various scripts into a single script.

Note: If you're going to use Perl DBI - you'll have to build the DBM: Smiley Surprised

racle module (search the forum for info on that - it's not "trivial")