topic Re: TOS and Lotus Domino in Talend Studio

TOS and Lotus Domino

erwan2 — Sat, 16 Nov 2024 14:25:49 GMT

Hi,
does anyone use Talend to access Domino databases ?
I can't get values of subforms' fields... is there a way to do ?
Thank you
--
R

PS: how do you connect to the database ? (I use tJDBCxxx)

Re: TOS and Lotus Domino

Anonymous — Fri, 14 Mar 2008 06:39:16 GMT

Hello
Current, there is not a specific DB component (like tMySQLInput for MySQL database) for Lotus Domino database. You can report a feature on our bugtracker.
Best regards
shong

Re: TOS and Lotus Domino

erwan2 — Fri, 14 Mar 2008 08:00:20 GMT

Hi,
I found a solution...
When you use the JDBC driver for Lotus Domino, you can do SQL queries. These queries can be done either on a form (select LastName from MSKPerson) or on the database's title (select LastName from Annuaire where form='MSKPerson').
The first query doesn't return fields included in subforms, the second one does.
Regards.
--
R

Re: TOS and Lotus Domino

Anonymous — Sat, 31 Jan 2009 18:20:41 GMT

We have a set of connectors (tNotesInput, tNotesOutput, tNotesRunAgent, etc) that integrate with Lotus Domino without needing to install and maintain the NotesSQL or JDBC drivers. Send me an email if you need more details.
_________________
Joe Wichowski
EBIZ Technology
www.ebiztech.com

Re: TOS and Lotus Domino

_AnonymousUser — Mon, 09 Mar 2009 19:35:18 GMT

Joe,
i would like to get more information on your connections to domino.

Re: TOS and Lotus Domino

Anonymous — Tue, 02 Jun 2009 20:44:31 GMT

Joe is there anyway I can get ahold of those connectors. I am having a difficult time using Generic ODBC to input information into a Lotus Notes database.

Re: TOS and Lotus Domino

_AnonymousUser — Wed, 17 Jun 2009 15:36:24 GMT

can no one help me push data to a lotus domino database from an oracle database

Re: TOS and Lotus Domino

Anonymous — Tue, 18 Aug 2009 10:34:52 GMT

I'm also trying to use Talend and NotesSQL together.
Getting datas from Notes databases is OK.
But I can't insert datas into Notes.
I've made a classical job with 2 tDBInput/Output and a tMap componnent.
Here is the error message:

Starting job Alim_Centrales at 11:02 18/08/2009.
 connecting to socket on port 3642
 connected
 connecting to socket on port 4654
 connected
Exception in component tDBOutput_1
java.sql.SQLException: Driver not capable
	at sun.jdbc.odbc.JdbcOdbc.createSQLException(Unknown Source)
	at sun.jdbc.odbc.JdbcOdbc.standardError(Unknown Source)
	at sun.jdbc.odbc.JdbcOdbc.SQLSetConnectOption(Unknown Source)
	at sun.jdbc.odbc.JdbcOdbcConnection.setAutoCommit(Unknown Source)
	at xales___decu.alim_centrales_0_1.Alim_Centrales.tMSSqlInput_1Process(Alim_Centrales.java:450)
	at xales___decu.alim_centrales_0_1.Alim_Centrales.runJobInTOS(Alim_Centrales.java:917)
	at xales___decu.alim_centrales_0_1.Alim_Centrales.main(Alim_Centrales.java:815)
 disconnected
 disconnected
Job Alim_Centrales ended at 11:02 18/08/2009.

I was thinking to a authorization problem but I successfully inserted rows into the Notes table via the Talend SQL builder (right-click on my table, "Edit queries").
Does anyone have an idea?

Jerome
Regards

Re: TOS and Lotus Domino

Anonymous — Tue, 18 Aug 2009 16:16:30 GMT

I tried to debug the job, and obviously, the NotesSQL ODBC driver doesn't like the setAutoCommit...
I comment the line (in debug mode) and the job runs fine (OK it has failed but after more than 1000 insert)
Can I comment this line for each execution?
Is there any way of managing the commitment in an other way?

Re: TOS and Lotus Domino

Anonymous — Wed, 18 Nov 2009 16:30:44 GMT

Hi,
I saw your message about TOS and Lotus connection, I also have the same problem,could you tell me how to link it together?
I configured odbc source in my laptop,and odbc testing is ok,then i open TOS to connect odbc source through "Generic DB" DB type,and fill in username and password, also datasource name, is the name I set in the "ODBC data source administrator". but always told me "connection failure,I need to change database setting"
Connection failure. You must change the Database Settings.
Data source name not found and no default driver specified
Pls let me know how to connection,thanks

Re: TOS and Lotus Domino

_AnonymousUser — Mon, 01 Feb 2010 11:04:18 GMT

Hi,
I want run talend batch file from asp .net to store data in DB. It shows an exception like this below ..
can anyone help how to resolve this??
Exception in component tDBOutput_1
java.sql.SQLException: Data source name not fou
nd and no default driver specified
at sun.jdbc.odbc.JdbcOdbc.createSQLException(Unknown Source)
at sun.jdbc.odbc.JdbcOdbc.standardError(Unknown Source)
at sun.jdbc.odbc.JdbcOdbc.SQLDriverConnect(Unknown Source)
at sun.jdbc.odbc.JdbcOdbcConnection.initialize(Unknown Source)
at sun.jdbc.odbc.JdbcOdbcDriver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at talenddemosjava.store2res_1_0_1.Store2Res_1.tFileInputDelimited_1Proc
ess(Store2Res_1.java:15960)
at talenddemosjava.store2res_1_0_1.Store2Res_1.runJobInTOS(Store2Res_1.j
ava:17588)
at talenddemosjava.store2res_1_0_1.Store2Res_1.runJob(Store2Res_1.java:1
7495)
at talenddemosjava.combinedoasisc_0_1.CombinedOasisC.tRunJob_2Process(Co
mbinedOasisC.java:534)
at talenddemosjava.combinedoasisc_0_1.CombinedOasisC.tRunJob_4Process(Co
mbinedOasisC.java:460)
at talenddemosjava.combinedoasisc_0_1.CombinedOasisC.tRunJob_1Process(Co
mbinedOasisC.java:334)
at talenddemosjava.combinedoasisc_0_1.CombinedOasisC.runJobInTOS(Combine
dOasisC.java:847)
at talenddemosjava.combinedoasisc_0_1.CombinedOasisC.main(CombinedOasisC
.java:747)
Exception in component tRunJob_2
java.lang.RuntimeException: Child job running failed
at talenddemosjava.combinedoasisc_0_1.CombinedOasisC.tRunJob_2Process(Co
mbinedOasisC.java:554)
at talenddemosjava.combinedoasisc_0_1.CombinedOasisC.tRunJob_4Process(Co
mbinedOasisC.java:460)
at talenddemosjava.combinedoasisc_0_1.CombinedOasisC.tRunJob_1Process(Co
mbinedOasisC.java:334)
at talenddemosjava.combinedoasisc_0_1.CombinedOasisC.runJobInTOS(Combine
dOasisC.java:847)
at talenddemosjava.combinedoasisc_0_1.CombinedOasisC.main(CombinedOasisC
.java:747)
I created dsn also.
Thanks in Advance.

Re: TOS and Lotus Domino

_AnonymousUser — Tue, 03 Jan 2012 22:11:25 GMT

Our connectors are now available on Talend Exchange. Enjoy...
/joe

Re: TOS and Lotus Domino

amateur_ak — Wed, 29 Apr 2020 13:32:27 GMT

I am currently looking for a lotus 1-2-3 connectors if you any have any idea or reference links please guides

Also, I would like to get the exchange link for the Domino connectors which you have posted?