Newbie questions - how to connect to enterprise data?

hcl-bot · April 16, 2013, 5:24am

I just started experimenting with Designer 9 for pure web development and here comes few newbie qustions.

1- What I understand Domino has a build-in server. Is there a console included in the system to print Java agent output as System.out.println and exceptions?

2- I tried to connect Domino to external rdbms Oracle by creating database connection DCR but it doesn’t work.

Is it because I am using local as a server?
Does it mean I need a Domino server to make it work?
Is there a free Domino server with docment database for web development for exprementing to download?
What are the best practices to integrate Domino with rdbms in xpages and views? Is creating data connection DCR right way to go? I followed this but I failed http://publib.boulder.ibm.com/infocenter/domhelp/v8r0/index.jsp?topic=%2Fcom.ibm.designer.domino.main.doc%2FH_USING_A_DATA_CONNECTION_RESOURCE_STEPS.html http://publib.boulder.ibm.com/infocenter/domhelp/v8r0/index.jsp?topic=%2Fcom.ibm.designer.domino.main.doc%2FH_USING_A_DATA_CONNECTION_RESOURCE_STEPS.html

thank you for any clues. //Regards

hcl-bot · April 27, 2013, 5:11am

Subject: RE: newbie questions - how to connect to enterprise data?

Thank you for a great answer.

hcl-bot · April 19, 2013, 10:40am

Subject: RE: newbie questions - how to connect to enterprise data?

A DCR only works with the DECS server application. If you want to connect to RDBMS from a Notes client, NotesSQL, the ODBC driver, will do that.

Unfortunately, IBM’s documentation is a jumble due to their attempt to force WebSphere and Composite Applications on the Lotus users a few years back. They started doing that, and we saw Domino Designer get migrated to Eclipse, which caused more confusion. Along with that, many opportunities. And this year, they removed the “Lotus” name from the product, but that change is also incomplete, and contributes to more confusion. The newer development model is focused on OSGi plugins, bundles and XPages. The Domino Designer tooling/documentation has bits of the old and new models in it. But for RDBMS data, you will want to learn about JDBC connectors in Domino.

Start from these slideshows for the more recent approach

http://www-10.lotus.com/ldd/ddwiki.nsf/dx/Video__Using_the_Relational_Controls_in_the_Extension_Library http://www-10.lotus.com/ldd/ddwiki.nsf/dx/Video__Using_the_Relational_Controls_in_the_Extension_Library

IBM Connect Sessions & Lotusphere Slides http://www.idonotes.com/IdoNotes/IdoConnect2013.nsf/dx/show104-buried-treasure-finding-the-hidden-gold-in-lotus-notes-data.htm

And yet another new model is that OpenNTF is hosting a lot of the Skunkworks development of new Domino Designer features, and their releases are not 100% in sync with IBM official releases.

OpenNTF.org - Open Source Community for Lotus Notes Domino http://www.openntf.org/Internal/home.nsf/blogsAll.xsp