Displaying documents from different databases in a single view

I have several databases (db vendorA, db vendorB, db vendorC and so on). The documents within these databases have category field with several values assigned (shoes,  caps, jackets and so on)

When a web user picks specific category, I need to select documents based on the chosen category in all the databases and display them on the web, in a single view - for example, all documents that have category "shoes" from all the vendors

I would prefer to keep databases separate.

I am considering to run an agent that would build collection of the documents, but not sure how much load it would bring to the server
LVL 17
fgrushevskyAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

mbonaciCommented:
Domino version?
The only way you can show documents from multiple databases in a single view is by using DB2 query view design element in Domino DB2 enabled databases, which became available in v7:
http://publib.boulder.ibm.com/infocenter/domhelp/v8r0/topic/com.ibm.designer.domino.main.doc/H_DB2_QUERY_VIEWS_1555_OVER.html

But why wouldn't you create separate view for each db (category) and then simply switch between views?
0
mbonaciCommented:
Those separate views would be each in its own database and then simply called by outline entry.

Another idea, you could use a page or form in your database, containing an embedded view. That view that's embedded may reside in another database.
0
fgrushevskyAuthor Commented:
Domino version is 8.5

DB2 query would require DB2 Access server

I could create separate view for each db and switch between them but it would not solve the problem
For example, let's say first DB is "Reebok", second DB is "Nike", another one is "Adidas" and so on.

what is needed that when user picks category, for example "sneakers", the site should display sneakers from all the vendors from different databases
0
Cloud Class® Course: CompTIA Cloud+

The CompTIA Cloud+ Basic training course will teach you about cloud concepts and models, data storage, networking, and network infrastructure.

mbonaciCommented:
There's no way you can do that, in a way you want, without DB2-enabling your Domino server.
0
jmaritzCommented:
There is always a way. Ha ha

There is a project on openNTF -
http://www.openntf.org/Projects/pmt.nsf/ProjectLookup/Domgle

The application was originaly done by domlike.net and called "Domgle" .

Basically you have a configuration document which specifies which databases on which servers you want to search, which fields and what you want returned. you just have to copy an agent into each database that you want to search and then run your search from this database, brings ebrything back as an html page with links to the dcouments.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
mbonaciCommented:
Domgle allows you to implement multi-database search, which is a long way from a view with documents from multiple databases.
That aside, Domgle is a great effort that you can customize (remove search box and feed the query from the code) to imitate your view (web only, of course).

But there's a far easier way to accomplish that. I've recently been working on XPages and came across the fact that (since you're using 8.5) you can create an XPage with multiple data sources:
http://planetlotus.org/469650
0
fgrushevskyAuthor Commented:
Thank you, guys

Domgle seems to hit the spot... and it is time to learn XPages
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Lotus IBM

From novice to tech pro — start learning today.