TOS and Lotus Domino

One Star

TOS and Lotus Domino

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)
Community Manager

Re: TOS and Lotus Domino

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
----------------------------------------------------------
Talend | Data Agility for Modern Business
One Star

Re: TOS and Lotus Domino

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
One Star

Re: TOS and Lotus Domino

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
One Star

Re: TOS and Lotus Domino

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

Re: TOS and Lotus Domino

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.
One Star

Re: TOS and Lotus Domino

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

Re: TOS and Lotus Domino

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
One Star

Re: TOS and Lotus Domino

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?
One Star

Re: TOS and Lotus Domino

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
One Star

Re: TOS and Lotus Domino

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.
One Star

Re: TOS and Lotus Domino

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