Results 1 to 4 of 4
  1. #1
    Join Date
    Aug 2004
    Posts
    6

    Unanswered: Enterprise (Direct) Connect alternatives?

    I'm wondering if there are any existing software packages that can facilitate a link between Sybase and various other servers (Oracle, MS SQL Server 2000, DB2, etc.) and what the experience has been using these other packages. Specifically, I'm interested in finding out the ease of installation, learning curve, dependability, etc.

    Any information would be very helpful...

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    PERL will inter-operate with all "major" databases.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Aug 2004
    Posts
    6
    Interconnectivity using a scripting language is not really an issue. We currently have a couple java classes that provide the data transfer as necessary -- the problem is that it is done more in batch mode rather than real time. The advantage of Enterprise Connect is that it provides real time updates to either side. Basically, the table exists in one environment and a proxy table exists in the other. Any updates, inserts, deletions, etc are immediately shown on both tables.
    The disadvantage of Enterprise Connect is its $375,000 licensing fee per environment. There are also individual packages to connect between Sybase and Oracle, Sybase and DB2, Sybase and MS SQL Server, etc.

  4. #4
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    There is a company called Golden Gate which has a product that might work for you.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •