Hi, [> Does anyone have ETL tools in mind that natively talk to Unidata?]
Not exactly "Talk to Unidata" ... Use Unidata to prepare tables/columns. At Infodata, we have our in-house ETL, written in SB+ and BASIC routines running under Unidata, Universe, D3. All definition's interfaces are in SB+, you define tables/columns from u2files and SB+ Expression (direct field or derived field) easily from am, vm, svm levels. The system generate SQL statements into script.sql files to create table on a "sql" datawarehouse Script.sql files are routed and submitted to "sql" Datawarehouse. We have experience with UniverseSQLSchema,DB2, MS-SQL, mySQL, Oracle. At runtime, some Basic routines extract data from u2files and create script.sql (INSERT,UPDATE,DELETE). You can specify a scheduled extraction, full, conditionnal, you can have incremental if triggers are set. Simple, easy, . If you are interested please reply to [EMAIL PROTECTED] (remove antispam.) Manu Fernandes Infodata-group.eu > -----Message d'origine----- > De : [EMAIL PROTECTED] [mailto:owner-u2- > [EMAIL PROTECTED] De la part de Jeff Butera > Envoyi : samedi 15 novembre 2008 04:45 > @ : u2-users@listserver.u2ug.org > Objet : [U2] Pentaho/ETL Tools > > We're in the midst of creating a data warehouse from our UniData > databases > and exploring the possibility of using Pentaho. Their ETL tool does > have > an entry for Universe (not Unidata), but the connection methods are > JDBC, > ODBC or JNDI. > > We don't want to create an SQL-view of Unidata merely for ETL, we'd > prefer > to find an ETL tool that can natively talk with Unidata. > > Has anyone worked with Pentaho? Any thoughts? > > Does anyone have ETL tools in mind that natively talk to Unidata? > > Jeff Butera, Ph.D. > Administrative Systems > Hampshire College > [EMAIL PROTECTED] > 413-559-5556 > > "But Dad, I'm not listening to you." > Catherine Butera > ------- > u2-users mailing list > u2-users@listserver.u2ug.org > To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/