Creating a view from an external database

25 pts.
Tags:
Database Views
Domino Designer 8.5
Lotus Domino
I am working with Domino designer 8.5 () and have a form that contains a field of type 'Names' that has the Choices set to 'Use View dialog for choices' (as there are a lot of entries to choice from I choice the view dialog to allow sorting and searching). The view that I use is constructed from 2 external databases where an identifier and a label are extracted along with the name of the source. The identifier is then stored in the form. This view however is managed manually, so whenever there is a change in one of the source databases I need to update the view with manual entries or imports. Is there an easy way to create such a view dynamically, or at least automatically from an external database? Or is there another way to go about this to get the same result. Thanks for any help.

Answer Wiki

Thanks. We'll let you know when a new response is added.

How up-to-date does your view need to be? You could simply run an agent on a schedule (nightly, or every 4 hours, or whatever) to update the view with the most recent data.

Discuss This Question: 4  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Agu
    Thanks for the advice, nightly updates would be sufficient. Do you know of any links that explain clearly how to update a view from an external db with an agent?
    25 pointsBadges:
    report
  • Stiletto
    You don't really update views; you update the documents that are displayed by the view. That said, which part of the process are you unsure of? Updating documents with an agent? Or, scheduling an agent?
    3,420 pointsBadges:
    report
  • Agu
    Scheduling an agent should be ok (in any case, even running the agent from the action menu would be acceptable). It is more with the part of updating documents with an agent , specifically as the data shall come from an external db. I probably need to study updating documents with an agent in the first instance then look at adding the link to external data after.
    25 pointsBadges:
    report
  • Stiletto
    How you do this will depend on what type of file the external database is. For example, I use DECS to read a DB2 file on our mainframe.
    3,420 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following