HomeForum
Welcome, Guest

Read data from Sybase database and store the same into an oracle database
(1 viewing) (1) Guest
Data Warehousing and Data integration
  • Page:
  • 1

TOPIC: Read data from Sybase database and store the same into an oracle database

Read data from Sybase database and store the same into an oracle database 10 months ago #3244

  • Jatin
  • OFFLINE
  • Fresh Boarder
  • Posts: 4
  • Karma: 0
Hi,

Does this tool allow us to read data from Sybase database and store the same into an oracle database?
Does this tool require any specific database as its backend ?

Mike

Re: Read data from Sybase database and store the same into an oracle database 10 months ago #3245

  • admin
  • OFFLINE
  • Moderator
  • Posts: 2183
  • Karma: 12
> Hi,
>
> Does this tool allow us to read data from Sybase database and store the
> same into an oracle database ?

It does.

> Does this tool require any specific database as its backend ?

It does, default one is MS Acess or you can use Oracle, MS SQL Server, MySQL, PostgreSQL or Interbase


Mike


What is "THIS TOOL" ANYWAY?

Re: Read data from Sybase database and store the same into an oracle database 10 months ago #3246

  • Jatin
  • OFFLINE
  • Fresh Boarder
  • Posts: 4
  • Karma: 0
Hi,

Thanks for the response. Will you be able to let us know the steps that we need to follow to access sybase data and store it in oracle. What all is reqd at both ends ? How do we automate this activity ?

Rgds,
Jatin

Re: Read data from Sybase database and store the same into an oracle database 10 months ago #3247

  • admin
  • OFFLINE
  • Moderator
  • Posts: 2183
  • Karma: 12
Hello

First of all you would need to download and install Advanced ETL Processor.
www.dbsoftlab.com/Download-document/33-A...L-Processor-Ent.html

Than you would need to install oracle client and sysbase client including ODBC driver

Have a look a this online tutorial
www.dbsoftlab.com/Advanced-ETL-Processor...d-ETL-Processor.html

It will give a brief introduction to mapping process

There are also some examples in our documentation

Mike
  • Page:
  • 1
Time to create page: 0.17 seconds

Testimonials

We Process 3000 files daily, 24h x 365d

C Gandhi
Nesa-Canada

User Login

You only need to log in or register to use our support forum



Our customers

BP

BBC

HSBC


Databases we work with

Go to top