XML-DBMS Anyone?

Env: TS 6.7.1 SP1 Linux

My objective is to create DCRs comprised of multiple queries from a DB. For example, my DCR XML would resemble:

[html] 111121212 doo hickey
English

[/html]

with values produced from complex queries of multiple tables.

I ran across the XML-DBMS project on Sourceforge and was wondering if anyone has any experience using this module. Furthermore (to the Perl genuises) is there any other recommended/conventional methods for doing the same using other common modules?

TIA

Find more posts tagged with

Comments

Adam Stoller

Env: TS 6.7.1 SP1 Linux

My objective is to create DCRs comprised of multiple queries from a DB. For example, my DCR XML would resemble:

[html] 111121212 doo hickey
English

[/html]

with values produced from complex queries of multiple tables.

I ran across the XML-DBMS project on Sourceforge and was wondering if anyone has any experience using this module. Furthermore (to the Perl genuises) is there any other recommended/conventional methods for doing the same using other common modules?

TIA

I'm not quite clear on what you're asking.
Are you trying to create DCRs of the queries? the results of the queries? or a combination of the two?

What's the use-case scenario for the DCR after it's been created?

ReggieRWalker

I'm not quite clear on what you're asking.
Are you trying to create DCRs of the queries? the results of the queries? or a combination of the two?

What's the use-case scenario for the DCR after it's been created?

I'll be creating DCRs from the queries. Essentially, I'll be using TeamSite as a "poor man's" product catalog management tool. The product data currently lives in the DB. To prevent our users from having to re-enter all 10000+ products into DCTs, I want to create the XML from the DB. Once I create the XML (DCRs), I'll then tag them with the necessary EA's.

Adam Stoller

I'll be creating DCRs from the queries. Essentially, I'll be using TeamSite as a "poor man's" product catalog management tool. The product data currently lives in the DB. To prevent our users from having to re-enter all 10000+ products into DCTs, I want to create the XML from the DB. Once I create the XML (DCRs), I'll then tag them with the necessary EA's.

So the objective here is to have the bare-bones query information in the DCR and have the PT use that information to perform that query against the DB to retrieve the data and present it in a web page (or similar) - yes?

Doesn't sound that difficult - it's basically making sure you have the proper modules installed and environment information specified within your PT so that the query can be performed and then doing whatever you want from there.

With the perl-style PTs you can use either iw_sql tags or code directly in Perl.

With the XSLT PT's - I'm not sure how one queries a database... (I imagine it's possible, but I haven't done it)

cesarecastro

ReggieRWalker

I think you just answered your own question. We had to perform the same task when we moved our Product Catalog from a database into Teamsite.

Here is what we did:

1. Got a product catalog extract from old tool/database in excel format.
2. migrated data into our own database
3. Transform data into DCRs (with perl scripts, not too hard to do, we added a couple of new fields) and put in TS
4. Apply EAs.
5. You are done.