Re: PostgreSQL and Data warehousing question
От | Robert Treat |
---|---|
Тема | Re: PostgreSQL and Data warehousing question |
Дата | |
Msg-id | 1042734035.12024.8.camel@camel обсуждение исходный текст |
Ответ на | PostgreSQL and Data warehousing question (Justin Clift <justin@postgresql.org>) |
Список | pgsql-general |
On Wed, 2003-01-15 at 20:47, Justin Clift wrote: > > 2) Could we continue to use our Informatica Power Center suite of tools > to peform our ETL processes?, and are their 'hooks' available for > Informatica? > > We would also want to continue to use our data modeling tool, ErWin, to > create the DDL to build our DW tables. Will this DDL work with > PostgreSQL? And we can't leave out the BI layer. Would be able to use > our standard BI tools, i.e. Power Analyzer, Crystal, Cognos, etc.? > Crystal reports works fairly well via ODBC. Erwin 3.x has some support for postgresql, though it's not great if you write postgresql specific stuff. My understanding is this has been improved in later versions of erwin, though I've not tried them. FWIW all of these tools should work on some level due to odbc (or perhaps jdbc) compatibility. The quality of support though is probably less than that for oracle or sql server, but it it's still likely they would be good enough to do the job. Robert Treat
В списке pgsql-general по дате отправления: