Re: Beginner's question about ODBC and/or foreign data sources

From: George Roberge <groberge(at)andforthelamb(dot)org>
To: Andrej <andrej(dot)groups(at)gmail(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Beginner's question about ODBC and/or foreign data sources
Date: 2012-10-18 01:56:53
Message-ID: 507F61E5.6090005@andforthelamb.org
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-novice

On 10/17/2012 09:42 PM, Andrej wrote:
> On 18 October 2012 13:57, George Roberge <groberge(at)andforthelamb(dot)org> wrote:
>>> Maybe I completely misunderstood this initial paragraph of your mail,
>>> but how does using postgres to look at other windows data sources comprise a
>>> replacement for access?
>> Oh sure.
>>
>> That was just a very broad (and useless as far as my actual questions go)
>> statement legitimizing my question's existence on the planet!
> LOL ...
>
>> It is a long-term goal to break PostgreSQL into the workplace, and
>> eventually use it enough that perhaps Access will disappear. It's a battle
>> against "The Machine" of course, but hey....
>>
>> The data source is a Syspro ERP ODBC source. Access naturally readily
>> connects to this source, and we supplement the ERP with a few Access
>> databases when we need to use its data in ways that the ERP doesn't handle.
>
> So you're primarily using access as a front-end/GUI to your ERP system, with
> a little extra ooomph? If that's the case postgres probably isn't the cure for
> your access ailments :}
>
> Most likely you'll need a custom made GUI app, and possibly use postgres
> for the "and then some" bits from the same app.
>
>
>
>
>> George R.
> Cheers,
> Andrej
>
>
>
>
>
We're using the data in the ODBC linked tables, and writing queries,
forms, labels, and reports from the raw data, in Access databases. The
ERP itself is a monolithic package with plenty of screens, but some
people need only certain information (labels, for example) on the shop
floor. Other uses are more easily-designed reports and various sales
and customer service figures.

Access has served the company well as far as a RAD tool, but has been
used a little sloppily. It's time to overhaul some of the systems, and
I'm an Open Source kind of guy, so I lean more towards those tools.

I've been thinking about the possibility of using a simple web browser
as a front end, but that's a story for another day.

Thank you for your posts!
George R.

--
George Roberge
www.andforthelamb.org

-- If Bill Gates had a nickel for every time Windows crashed... oh, wait....

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Frank Lanitz 2012-10-18 10:37:40 Re: count() in 9.2
Previous Message Andrej 2012-10-18 01:42:14 Re: Beginner's question about ODBC and/or foreign data sources