Re: Data Access Middleware & a Business User's view of data

Hi Ron,

ODBC (Open Database Connectivity) is for this very purpose. Microsoft's ADO will allow you to connect to almost any datasource - from RDBMS's through flat files to spreadsheets, etc.

You will need to do appreciable modifications to present the data as you see fit, however.

Good luck.
Manny.

"Ron" <ronsmyname_at_yahoo.com> wrote in message news:bfbbd0cc.0110031658.43a943b1_at_posting.google.com...
> Hello,
>
> I need to increase my knowledge about "data access middleware" and my
> questions will probably reinforce that fact!
>
> Can anyone recommend a solution that can be used to provide multiple
> software applications & users access to multiple data sources via a
> single common logical piece of software (i.e. data access middleware)?
>
> With capabilities that may include:
>
> - Presenting a common simplified view of our databases and data
> sources via a business user oriented metadata layer. Primarily for
> persons using reporting tools but possibly also our software
> developers.
>
> - Connecting to and joining together multiple different databases via
> the one interface.
>
> - Insulating applications from changes to those data sources.
>
> - Providing an additional level of security within the middleware.
>
> What might you expect to pay?
>
> Thanks,
>
> Ron
Received on Thu Oct 04 2001 - 23:20:32 CEST