: 3492 | 87812 | 9797
|
: 91 : 91 : 0 |
XPages should have native access to RDB data. This will allow the use of external SQL data in views and forms in conjunction with Notes data. Moving Domino Designer to Eclipse was a big step forward in opening up the propertairy technology of the Lotus Notes development platform. The next step to wider acceptance of Lotus Notes as an application development platform is to allow the tool to easily integrate with other systems in a corporate environment.
Sure you can write java sql procedures and call them now from XPages server side javascript. But this is a one off solution and more of a work around. Or you can write routines to bring in this data into Notes (or use a third party product), but again this is additional work and effort and adds to the complexity of what should be a simple task. Why shouldn't the developer be able to point and click and have data come from multiple data sources as with other development platforms?
I know this has been mentioned as a future enhancement for XPages but I feel we need to drum up support to make sure this happens.
|
1) Larry Helwig (06 Jul 2009)
YES - but not just to DB2
2) John Mackey (06 Jul 2009)
Yes, I agree. At least the major rdb systems: DB2, SQL Server, Oracle, MySQL
3) Pascal Vachon (06 Jul 2009)
Same here!
I agree, DB2, MSSQL, MySQL and Oracle.
I agree, DB2, MSSQL, MySQL and Oracle.
4) Tom Oneil (06 Jul 2009)
I'll agree but I think it will be seldom used. Visual Studio has had ASP.NET database integration for years but all of the good developers write the data access layer on the back end.
5) Roland Reddekop (06 Jul 2009)
I am primarily interested in access data to our "i" (i5/OS) through Xpages, but definitely Lotus Domino needs the other backends mentioned to become a serious player in the web dev world.
We have many apps accessing this data now through LCLSX and DECS, but its limited in what you can do.
We have many apps accessing this data now through LCLSX and DECS, but its limited in what you can do.
6) Ben Langhinrichs (06 Jul 2009)
To play devil's advocate just a bit, why would this be more widely used than the NSFDB2 features that were requested for years and not extensively used when they were available?
7) Bruce Elgort (06 Jul 2009)
@Ben,
Because we have SQL Server dbs and other non DB2 data sources out there that we would just love to access data from.
Because we have SQL Server dbs and other non DB2 data sources out there that we would just love to access data from.
8) Peter Presnell (07 Jul 2009)
I believe IBM have already announced this feature is coming in a future release of Notes.
9) Arshad Mahmoud (07 Jul 2009)
Yes, I agree. bring it on par with ASP.net
10) John Mackey (07 Jul 2009)
@Ben, the NSFDB2 is different then this request. That was/is a datastore for Notes. This request is to add the ability to natively access data in other systems as well as Notes. Many of the applications in the corporations I have worked on require interaction with other applications across an enterprise, where reading and writing of RDB data in conjunction with my Notes data is required.
As a consultant I see this play out all the time. Corporations have Notes development groups as well as other competing development groups. A request comes in for a new application to a work intake manager. The request is assessed and assigned to the appropriate development team. If part of requirement is to access data from a RDB system, it is immediately assigned to a non-Notes team... unless there is a huge reason it has to be in Notes.
Native support for RDB will help DDE compete.
As a consultant I see this play out all the time. Corporations have Notes development groups as well as other competing development groups. A request comes in for a new application to a work intake manager. The request is assessed and assigned to the appropriate development team. If part of requirement is to access data from a RDB system, it is immediately assigned to a non-Notes team... unless there is a huge reason it has to be in Notes.
Native support for RDB will help DDE compete.
11) Angelo Pampalone (07 Jul 2009)
Me too
Integrate with the big 4: DB2, MSSQL, MySQL and Oracle.
Integrate with the big 4: DB2, MSSQL, MySQL and Oracle.
12) Roland Reddekop (07 Jul 2009)
@those comparing this request to the defunct NSFDB2:
As John pointed out NSFDB2 isn't comparable to this request. I haven't the foggiest why IBM chose to port the entire NSF itself into DB2 when all we really wanted was the ability to read/write from other databases using basic SQL in a way that was more flexible than LEI, LCLSX, and DECS. Being on the "i" platform at my org we never got to taste it (fortunately so or I for certain would have had egg on my face and a mountain of legacy apps). IBM bit off more than they could chew and it fell apart. This request to create a simple interface to non-notes data has a reasonable scope and is strategic with real world practical benefits. The only reason I could imagine IBM would not do it would be due to internal competition between product managers and a fear of cannibalizing their other product's profit margins. If you can do it in Notes, why pay big dollars for_____.
As John pointed out NSFDB2 isn't comparable to this request. I haven't the foggiest why IBM chose to port the entire NSF itself into DB2 when all we really wanted was the ability to read/write from other databases using basic SQL in a way that was more flexible than LEI, LCLSX, and DECS. Being on the "i" platform at my org we never got to taste it (fortunately so or I for certain would have had egg on my face and a mountain of legacy apps). IBM bit off more than they could chew and it fell apart. This request to create a simple interface to non-notes data has a reasonable scope and is strategic with real world practical benefits. The only reason I could imagine IBM would not do it would be due to internal competition between product managers and a fear of cannibalizing their other product's profit margins. If you can do it in Notes, why pay big dollars for_____.
13) Marie-Claude Mayrand (08 Jul 2009)
I agree, Native access should be there for major RDB
14) Starrow Pan (13 Jul 2009)
An IBM consultant said more db source would be added to xPage in a demo.
15) Markus Köstner (13 Jul 2009)
Why not JDBC? Its standard and you could access almost every database you want.
16) John Mackey (13 Jul 2009)
@Markus, I would assume it's JDBC. That's up to IBM however. I mentioned the 4 RDBs that are essential whatever technology they use to implement the access.
@Starrow, this is an item that is being planned for a release, IBM has stated that. The issue is will it be sooner or later. I feel it should be high on the priority list.
@Starrow, this is an item that is being planned for a release, IBM has stated that. The issue is will it be sooner or later. I feel it should be high on the priority list.
17) David Wilkerson (17 Jul 2009)
Yes. I think that it is a serious omission that undermines the credibility of IBM's fidelity to the Domino platform. Too often they seem to hobble there products to drive customers to the 'more scalable' enterprise solution (J2EE based). I think that Domino has been a very strong player in the SMB market but for XPages to robustly deliver new life to the platform there must be RDM connectivity.
18) VIjaya Kumar (29 Jul 2009)
We should promote Notes Designer as universal development tool , and only competing product against .net . so the data population from any RDBMS is must. IBM should consider seriously and soon not in version 9 or 10 jerk.
19) John Turnbow (07 Aug 2009)
Yes Please!!!!
20) Lars Berntrop-Bos (16 Nov 2009)
I'm flabbergasted that JDBC isn't already supported.
ASAP please!
ASAP please!
21) Andreas Imnitzer (17 Nov 2009)
I second Roland (#12). Moving from green screens to Xpages, maybe? Hey, IBM, it's both IBM technology, so start the engines.
Buy IdeaJam Today!
You can run IdeaJam in your company. It's easy to install, setup and customize and your employees and customers will immediately see results.
Phone: +1 (360) 450-5022
Email: sales@elguji.com
Learn more >>
Welcome to IdeaJam
IdeaJam is a place where people can post and share their ideas, and gauge the marketability, popularity and viability with input from others.
When an idea gets posted, others can help promote or demote the idea and provide comments. Popular ideas will bubble to the top.
Make your opinion count.
 | SharePost your idea - from ways we can improve IBM Lotus Software to things we've haven't even yet thought of. |
 | VoteCheck out other people's ideas and vote on the ones you like best. The community votes. The community decides. |
 | DiscussTalk about ideas with your peers in the IBM Lotus Community and help make them even better. |
IdeaJam developed by
Hosting by
IdeaJam is a registered trademark of Elguji Software, LLC. Report a Bug
IdeaJam Copyright © 2007-2010 Elguji Software, LLC (1.8 PR 1 (Summer '10) - August 31, 2010)