deploying XML files using Data Deploy

Hi!!!

I am facing problem in deploying XML files using Data Deploy.
I want to deploy my whole dcr as in one column of database.

so in the database i have taken that column as XML type and in the deployment descriptor i dont know how to map it.

Since I want to deploy my whole xml file (all its content) as one of the column field of database, for that i need a solution.

The Environment that i am using is Interwoven TeamSite 6.5.0 Service Pack 2
on Windows Server 2003.

Find more posts tagged with

Comments

Adam Stoller

Hi!!!

I am facing problem in deploying XML files using Data Deploy.
I want to deploy my whole dcr as in one column of database.

so in the database i have taken that column as XML type and in the deployment descriptor i dont know how to map it.

Since I want to deploy my whole xml file (all its content) as one of the column field of database, for that i need a solution.

The Environment that i am using is Interwoven TeamSite 6.5.0 Service Pack 2
on Windows Server 2003.

First question: WHY?

What are you trying to achieve by deploying all the content portions of your DCR into a single column in a DB? Or do you means you're trying to deploy it as a (I believe the term is) narrow-tuple?

PATH | STATE | KEY | VALUE

If you really want to deploy the entire XML (structure and content) into the DB - then I don't think you want to use DD - I think you want to use something simpler like Perl: Smiley Very Happy

BI or some equivalent - since DD is intended to parse the XML to send pieces of it into different columns in the receiving DB - not to send the entire XML as one chunk into the DB.

Bill Klish

fish is right, DataDeploy is not your answer. What DataDeploy does is extract each of your individual xml elements within a document, which it sounds like isn't what you want.

Just write a custom script to do this. I must say I don't really understand why you would want to store the whole document in one column though.

Ambuj

Hi!!!

I am facing problem in deploying XML files using Data Deploy.
I want to deploy my whole dcr as in one column of database.

so in the database i have taken that column as XML type and in the deployment descriptor i dont know how to map it.

Since I want to deploy my whole xml file (all its content) as one of the column field of database, for that i need a solution.

The Environment that i am using is Interwoven TeamSite 6.5.0 Service Pack 2
on Windows Server 2003.

As answered above i'm also not sure as why you want to store the entire DCR in database.. but if it is your requirement I would suggest below..

1. Open Deploy the DCR to web server.
2. Insert a link to your database.

If you need the entire DCR in your database then...

3. Write a after intsert trigger on the table where you are inserting link.
4. Insert the DCR (an XML) to your database from your web server.

This will allow you to have your DCR in database as well as on your web server.

Hope this helps..

Cheers,
Nitesh Ambuj

msrinivas

As answered above i'm also not sure as why you want to store the entire DCR in database.. but if it is your requirement I would suggest below..

1. Open Deploy the DCR to web server.
2. Insert a link to your database.

If you need the entire DCR in your database then...

3. Write a after intsert trigger on the table where you are inserting link.
4. Insert the DCR (an XML) to your database from your web server.

This will allow you to have your DCR in database as well as on your web server.

Hope this helps..

Cheers,
Nitesh Ambuj

I am sorry if this is a really stupid question. Why exactly would you want to deploy the DCR to the web server?

XMLA.zip

Ambuj

I am sorry if this is a really stupid question. Why exactly would you want to deploy the DCR to the web server?

As per the question.. there's a requirement to deploy DCR to the database... I am not sure as how this is going help but still if that's the requirement I just suggested as what kind of other alternatives he can think...

Cheers,
Ambuj Smiley Happy

Prats01

Thanks a lot for all your suggestions,but still my actual requirements has not been accomplished....

Actually as part of the deployment,i am building a custom XML file which would contain some content from DCR and i want to store that in a third party DB in a xmltype column.

I want to leverage Datadeploy as the deployments to other systems happens thru DD,the current system deploys images to DB-Blob content type using DD and i would want to extend it to store XMLs into a table,xmltype column.
This is my actual requirement..

would it be possible???
Help me out !!!!

Ambuj

Thanks a lot for all your suggestions,but still my actual requirements has not been accomplished....

Actually as part of the deployment,i am building a custom XML file which would contain some content from DCR and i want to store that in a third party DB in a xmltype column.

I want to leverage Datadeploy as the deployments to other systems happens thru DD,the current system deploys images to DB-Blob content type using DD and i would want to extend it to store XMLs into a table,xmltype column.
This is my actual requirement..

would it be possible???
Help me out !!!!

XML files will go into CLOB data-type into database... Please enquire from Interwoven support whether they support this CLOB configuration from DataDeploy or not...

Cheers,
Ambuj Smiley Happy

Adam Stoller

Thanks a lot for all your suggestions,but still my actual requirements has not been accomplished....

Actually as part of the deployment,i am building a custom XML file which would contain some content from DCR and i want to store that in a third party DB in a xmltype column.

I want to leverage Datadeploy as the deployments to other systems happens thru DD,the current system deploys images to DB-Blob content type using DD and i would want to extend it to store XMLs into a table,xmltype column.
This is my actual requirement..

would it be possible???
Help me out !!!!

I think that the only way you'd be able to do this with DD is by developing your own custom tuple preprocessor that took the N fields of the XML file being processed - combined them into one XML string, and then deployed that XML string into a specific column in your table. (I suppose you might also be able to do this as a DB trigger action too - depends on whether you feel more comfortable coding for the DD customization or the DB customization.

The other possibility, as I mentioned before is to code this using something like Perl: Smiley Very Happy

BI - in which case, I believe, the coding is more straight-forward and easier to maintain over time.

Whatever you choose - you need (I believe) to do your own custom coding.