Data Warehouse - OPEN SOURCE

HOLA A TODOS, SE QUE HAY POCO DE ESTO, PERO NECESITO INFORMACION DE APLICACION DATAWAREHOUSE OPEN SOURCE

GRACIAS

Tenes : mondrian y OpenI ambos de sourceforge.net
fijate ahi

Ajejandra:
Tenes una herramienta muy interesante en www.pentaho.org
Aca la estamos tratando de integrar de a poco a las aplicaciones que tenemos funcionando en postgres
Basicamente tenes un front end en jsp que corre con tomcat y te permite escribir los indicadores de tu dw en lenguaje MDX (que creo, es original de microsoft).
Si por esas casualidades ya viste algo contame porque andamos buscando cosas por el estilo.
Saludos.

Hola veo que haces referencia a Pentaho; espero me puedas dar tu opinion

aqui estamos haciendo pruebas con Pentaho y la base de Datos vertica.

todo va bien hasta que hago la configuracion de la BD en el Pentaho Integration. aqui me sale el siguiente error que no me deja continuar.

Le agradezco si sabes algo

org.pentaho.di.core.exception.KettleException:
Error connecting to the repository!

Error occured while trying to connect to the database

Error connecting to database: (using class com.vertica.Driver)
Something unusual has occured to cause the driver to fail. Please report this exception.


at org.pentaho.di.repository.kdr.delegates.KettleDatabaseRepositoryConnectionDelegate.connect(KettleDatabaseRepositoryConnectionDelegate.java:154)
at org.pentaho.di.repository.kdr.KettleDatabaseRepository.connect(KettleDatabaseRepository.java:171)
at org.pentaho.di.repository.kdr.KettleDatabaseRepository.connect(KettleDatabaseRepository.java:161)
at org.pentaho.di.ui.repository.RepositoriesHelper.loginToRepository(RepositoriesHelper.java:242)
at org.pentaho.di.ui.repository.controllers.RepositoriesController$3.run(RepositoriesController.java:187)
at java.lang.Thread.run(Thread.java:619)
Caused by: org.pentaho.di.core.exception.KettleDatabaseException:
Error occured while trying to connect to the database

Error connecting to database: (using class com.vertica.Driver)
Something unusual has occured to cause the driver to fail. Please report this exception.

at org.pentaho.di.core.database.Database.normalConnect(Database.java:363)
at org.pentaho.di.core.database.Database.connect(Database.java:312)
at org.pentaho.di.core.database.Database.connect(Database.java:274)
at org.pentaho.di.core.database.Database.connect(Database.java:264)
at org.pentaho.di.repository.kdr.delegates.KettleDatabaseRepositoryConnectionDelegate.connect(KettleDatabaseRepositoryConnectionDelegate.java:131)
... 5 more
Caused by: org.pentaho.di.core.exception.KettleDatabaseException:
Error connecting to database: (using class com.vertica.Driver)
Something unusual has occured to cause the driver to fail. Please report this exception.

at org.pentaho.di.core.database.Database.connectUsingClass(Database.java:486)
at org.pentaho.di.core.database.Database.normalConnect(Database.java:347)
... 9 more
Caused by: com.vertica.util.PSQLException: Something unusual has occured to cause the driver to fail. Please report this exception.
at com.vertica.Driver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(DriverManager.java:582)
at java.sql.DriverManager.getConnection(DriverManager.java:185)
at org.pentaho.di.core.database.Database.connectUsingClass(Database.java:467)
... 10 more
Caused by: java.lang.NullPointerException
at com.vertica.core.v3.QueryExecutorImpl.receiveRFQ(Unknown Source)
at com.vertica.core.v3.QueryExecutorImpl.processResults(Unknown Source)
at com.vertica.core.v3.QueryExecutorImpl.execute(Unknown Source)
at com.vertica.core.v3.ConnectionFactoryImpl.runSetupQuery(Unknown Source)
at com.vertica.core.v3.ConnectionFactoryImpl.runInitialQueries(Unknown Source)
at com.vertica.core.v3.ConnectionFactoryImpl.openConnectionImpl(Unknown Source)
at com.vertica.core.ConnectionFactory.openConnection(Unknown Source)
at com.vertica.jdbc2.AbstractJdbc2Connection.<init>(Unknown Source)
at com.vertica.jdbc3.AbstractJdbc3Connection.<init>(Unknown Source)
at com.vertica.jdbc3g.Jdbc3gConnection.<init>(Unknown Source)
at com.vertica.Driver.makeConnection(Unknown Source)

Tenés una exahustiva lista en este sitio:

http://todobi.blogspot.com/2005/12/estudio-las-herramientas-open-source.html

Al final de la pagina.

Suerte