Re: open source linux -> windows database connectivity?

2009-11-18 Thread Tony Schmidt
Woo-hoo! Forget ODBC. Got this working with Jython and JDBC drivers! On Nov 13, 1:03 am, "M.-A. Lemburg" wrote: > TonySchmidtwrote: > >> Note: The client part of this product is free. You only need to > >> get a license for the server part. > > > Yeah, but don't I need the server part to make t

Re: open source linux -> windows database connectivity?

2009-11-12 Thread Tony Schmidt
>Note: The client part of this product is free. You only need to >get a license for the server part. Yeah, but don't I need the server part to make the connection? Would it be possible to use Jython and the Pervasive JDBC driver for this? On Nov 12, 2:56 pm, "M.-A. Lemburg

open source linux -> windows database connectivity?

2009-11-12 Thread Tony Schmidt
I am trying to read a Pervasive database on a Windows machine from a Python script on a Linux machine. I understand that this can be done with a proprietary ODBC-to-ODBC bridge called mxODBC or Easysoft OOB. Is there anyway to do this with existing free/ open source tools? Thanks in advance for

Re: custom data warehouse in python vs. out-of-the-box ETL tool

2009-09-24 Thread Tony Schmidt
Hi, Marc-Andre - well, so far you seem to be the only one suggesting that cross-database joins is the way to go - everyone else has been telling me to build a warehouse. I initially was trying to avoid the warehouse idea to "avoid going through the external temporary resource", as you say. But th

Re: custom data warehouse in python vs. out-of-the-box ETL tool

2009-09-24 Thread Tony Schmidt
@Martin: Thanks for your great feedback. So do you think it would be very beneficial for me to start with an Inman or Kimball book? Or do you think it would be just leisure reading and not very practical at best - fill my head with needless jargon and inflexible dogmas, at worst? I took a datab