Due to recent updates, all users are required to create an Altair One account to login to the RapidMiner community. Click the Register button to create your account using the same email that you have previously used to login to the RapidMiner community. This will ensure that any previously created content will be synced to your Altair One account. Once you login, you will be asked to provide a username that identifies you to other Community users. Email us at Community with questions.
how to add jdbc driver for data base connection (for analysing data)
michaelhecht
Member Posts: 89 Maven
Hi,
where can I add new drivers for data base connections for analysing data.
This is not described in the current documentation "5.1 Setting up Database Connections".
where can I add new drivers for data base connections for analysing data.
This is not described in the current documentation "5.1 Setting up Database Connections".
Tagged:
0
Answers
just place the JDBC JAR in the lib folder. What database system do you want to use?
Best,
Simon
If I then goto "Datenbankverbindungen" --> "Neue Verbindung einrichten" (sorry I've only the german translation)
I get all databases under "Datenbanksystem" that where delivred originally but not the new one (what's not surprising,
since even no classpath adaptation was done, etc.)
So I guess that there is to do a little bit more than just copying the jar file.
By the way: I want to use IBM Informix.
http://onjava.com/onjava/2004/02/25/jbossjdbc.html
but afterwards the server failed to start, so its obviously not the right way.
(By the way: IBM DB2 is also missing).
the link you post does not seem to be the latest to me :-) Try Section 7.3 on this page:
http://docs.jboss.org/jbossas/jboss4guide/r4/html/ch7.chapt.html
Also, in your JBoss (RA) folder you can find a sample for DB2 under docs/examples/jca.
In RA there is no counterpart for the "Manage Database Drivers" dialog you know from RM. However, you can simply define your data source using the -ds.xml file, assign it a JNDI name and then reference it from your "Read Database" operator via its JNDI name. (Or get an EE if you really need that dialog :-))
Best,
Simon
But having problems with connecting to DB2. JNDI= DB2DS?
Where exactly in "Read Database" operator I can reference to it?
I am facing issues with the third screen of the setup. I want to use Rapid Analytics with Microsoft SQL server. The user manual says it is possible, by placing the necessary JDBC driver in the folder you've mentioned. After doing this and using the wizard to start the installation, i get stuck at the "test connection" section
What are the default values to be given in Database Port and Database Schema for MS SQL server? Assuming that the DAtabase Host would be my machine URL.
Please help me out with this as i am not able to proceed further ???
I copied the jdbc driver to ../server/default/lib
Created "vertica-ds.xml" in ../server/default/deploy/ with changes for vertica
How do I use this connection into 'Read Database' Operator.
Works just fine with RapidMiner with 'Manage Database connections' and 'Manage Database drivers'
Really appreciate the help.
Update :
I selected 'jndi" as "define connection" in 'Read Database' parameters
when I give jndi name as 'VerticaDS' I getthe error as specified in boot.log after restarting the RapidAnalytics server ,
I get the following error
Cannot create example set meta data: Failed to lookup 'VerticaDS':
javax.naming.NoInitialContextException: Need to specify class name in environment or system property, or as an applet parameter, or in an application resource file: java.naming.factory.initial.
Any idea how to fix it ?
currently there is noway of adding new types of JDBC drivers via the Web interface (though you can of course configure the connections themselves). You could, by editing config files, but since you want to go via JNDI you don't have this problem anyway. I believe your JNDI name is wrong however. Shouldn't that be jndi/VerticaDS?
Best,
Simon
To use direct name, you could set the [tt]<use-java-context>false</use-java-context>[/tt] parameter.
Osisoft PIJDBC Asset Framework example:
See actual documentation: http://docs.jboss.org/jbossas/6/JCA_Guide/en-US/html_single/