Pentaho Error Testing Database Connection
Contents |
View Site Leaders Advanced Search Forum Pentaho Users BI Platform Error try conecting to SQL Server 2008 If this is your first visit, be sure to check out the FAQ by clicking the link pentaho sql server connection above. You may have to register before you can post: click the register link above pentaho oracle database connection to proceed. To start viewing messages, select the forum that you want to visit from the selection below. Results 1 to 3 pentaho database connection of 3 Thread: Error try conecting to SQL Server 2008 Thread Tools Show Printable Version Subscribe to this Thread… Search Thread Advanced Search Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode 07-01-2011,10:21 AM pentaho connection pooling #1 reynaldosp View Profile View Forum Posts Private Message Junior Member Join Date Jun 2011 Posts 1 Error try conecting to SQL Server 2008 I m trying conect to my SQL Server 2008 using this string: jdbc:sqlserver://192.168.200.159:1433/Test_DB; when try test conexion say "Error testing database connection. thank you Reply With Quote 07-27-2011,01:28 PM #2 Hellevig View Profile View Forum Posts Private Message Junior Member Join Date Apr 2011 Posts 1 Hello, I am getting this
Pentaho Oracle Jdbc Driver
same error trying to connect to SQL server 2008. Have you been able to figure it out? Thank you, Bonnie Reply With Quote 07-27-2011,04:33 PM #3 hazamonzo View Profile View Forum Posts Private Message Senior Member Join Date Oct 2006 Posts 219 If you're connecting to MS SQL Server 2008 be sure that you download the JTDS JDBC driver from sourceforge and copy it into the biservers tomcat/lib directory as well as the administration consoles lib/jdbc directory. Restart both the biserver and admin console. when you load into the admin console next you should be able to choose this driver to use. Then enter the jdbc url as something like this: jdbc:jtds:sqlserver://YOUR_HOSTNAME_HERE/YOUR_DATABASE_NAME_HERE Click Test. Should work Harris www.ivy-is.co.uk - Ivy Information Systems Come join the non official Pentaho IRC chat room on irc.freenode.net in the ##pentaho channel Reply With Quote Quick Navigation BI Platform Top Site Areas Settings Private Messages Subscriptions Who's Online Search Forums Forums Home Forums Pentaho Users BI Platform Pentaho Reporting Pentaho Data Integration [Kettle] Mondrian [Pentaho Analysis Services] Community Tools - CTools Metadata Pentaho Data Mining [WEKA] Big Data Pentaho Developers Agile BI Development and Methodology BI Platform Developer Reporting Developer Kettle Dev Mailing List Mondrian Mailing List User Experience Community Projects and Incubation New Analysis Client Tools Other Reporting Engines JBoss Rules in the Platform No
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company
Pentaho Jdbc Connection
Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs pentaho mysql connection Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 6.2 million programmers, pentaho database connection variable just like you, helping each other. Join them; it only takes a minute: Sign up Test database connection before step initialization in Pentaho Kettle? up vote 0 down vote favorite I am currently working on a transformation http://forums.pentaho.com/showthread.php?82849-Error-try-conecting-to-SQL-Server-2008 in Pentaho Kettle. I have numerous steps all depending on the same database connection. The username and password are provided by the user as parameters. If the wrong credentials are provided, every single step that is dependent on the database connection fails to initialize and logs a separate error about it. This results in a great wall of scary red text, that I am afraid will be quite hard to interpret for the intended http://stackoverflow.com/questions/32949109/test-database-connection-before-step-initialization-in-pentaho-kettle end user of the transformation. So, is there any way to test the database credentials before the other steps are initializing and then log a single informative error message if they are incorrect? database-connection pentaho kettle share|improve this question asked Oct 5 '15 at 12:50 Anders 3,99752035 couldn't you define a job containing two transformations, in the first get the database connection parameters, test the connection and only move forward if connection was successful? –Dirk Trilsbeek Oct 5 '15 at 13:37 @DirkTrilsbeek That is a smart workaround. Would prefer to have it all in one way, but if not possible your suggestion surely gets the job done. Thank you! –Anders Oct 5 '15 at 13:56 add a comment| 1 Answer 1 active oldest votes up vote 1 down vote You can try Check Db connections step in PDI Job. Here you can easily give all the connections that you are using in the job. Finally based on the connection setting, you can define your logic flow. Hope it helps :) share|improve this answer answered Oct 5 '15 at 13:51 Rishu 1,6981724 Interesting! Did not know about that step - will test how it works and report back! Thank you! –Anders Oct 5 '15 at 13:58 Just realized that the step is
here for a quick overview of the site Help Center Detailed http://stackoverflow.com/questions/20395453/unable-to-connect-to-oracle-via-pentaho-oracle-jdbc-driver-oracledriver-could answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the database connection Stack Overflow Community Stack Overflow is a community of 6.2 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up Unable to connect to oracle via Pentaho. 'oracle.jdbc.driver.OracleDriver' could not be found up vote 8 down vote favorite 1 Hi I've just pentaho database connection installed Pentaho Data Integration v. 5.01 and I'm trying to connect to a database. However, I'm unable to test the connection as I get the error (pasted below). I have JDK 1.7 installed on the system as well, however I can't seem to locate ojdbc14.jar anywhere. I downloaded that and pasted it in pentaho's \lib folder but I still get the same error. Any solutions to this problem? Error connecting to database [test] : org.pentaho.di.core.exception.KettleDatabaseException: Error occured while trying to connect to the database Driver class 'oracle.jdbc.driver.OracleDriver' could not be found, make sure the 'Oracle' driver (jar file) is installed. oracle.jdbc.driver.OracleDriver org.pentaho.di.core.exception.KettleDatabaseException: Error occured while trying to connect to the database Driver class 'oracle.jdbc.driver.OracleDriver' could not be found, make sure the 'Oracle' driver (jar file) is installed. oracle.jdbc.driver.OracleDriver at org.pentaho.di.core.database.Database.normalConnect(Database.java:415) at org.pentaho.di.core.database.Database.connect(Database.java:353) at org.pentaho.di.core.database.Database.connect(Database.java:306) at org.pentaho.di.core.database.Database.connect(Database.java:294) at org.pentaho.di.core.database.DatabaseFactory.getConnectionTestReport(DatabaseFactory.java:84) at org.pentaho.di.core.database.DatabaseMeta.testConnection(DatabaseMeta.java:2459) at org.pentaho.ui.database.event.DataHandler.testDatabaseConnection(DataHandler.java:541) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unkno