How much raw data are we talking about?
Why not use the Sybase jdbc driver or Macromedia's jdbc driver for
Sybase?
You could do a query of the remote Sybase db and cache it on your CF
server.
Depending on what is used on the internal server (do they have CFMX) to
update the Sybase db, it could trigger a cache refresh on your server.
Doing it this way you avoid duplication & synchronization of the db
copy.
If you must replicate the db, you prolly can use the Sybase and
SQL-Server functions provided for this purpose.
Depending on what is running on the internal system, you could write a
program to provide the data to a web service running on your system. I
would use a thinArray to eliiminate the XML overhead.
HTH
Dick
On Aug 25, 2004, at 7:36 AM, Kurt Knazek wrote:
> A client has asked us to pull data from a database (Sybase Adaptive
> Server
> Enterprise) that is hosted on their internal server and post the data
> to
> their web site.
>
> A little background information
>
> When the user log into the site they are presented with a page that
> needs to
> display some information from this Sybase db. The data in this
> database
> doesn't change hourly.
>
> My thought was to connect via an odbc connection nightly and dump the
> data
> into our sql server database. The problem with the odbc connections
> is the
> speed.
>
> Does anyone have other ideas ?
>
>
>
> Thanks
>
> /kurt
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
