| T.R | Title | User | Personal
Name | Date | Lines |
|---|
| 1072.1 | Might work | BROKE::ABUGOV | | Thu Jun 20 1996 13:56 | 21 |
|
Hi Cristina,
We've never done it, but if the EDA solution is complete and it works
then we should work with it.
You can use the Sybase gateway to write to Sybase. Currently to use
DDD you will need an Rdb database available - I'm not sure that is in
your environment. You can move data from one database to other simply
by using interactive SQL.
You would need:
Digital 2100 side Unisys side
----------------- -----------
Rdb trans. gway to EDA/SQL EDA/SQL Server
Rdb trans. gway to Sybase
Sybase Open Client
EDA/SQL Client
Sorry we have no way of testing this in house...
|
| 1072.2 | Needing more info... | ORAREP::VAXRIO::NOVELLO | Cristina Novello - Pre-sales/RJ | Thu Jun 20 1996 15:39 | 12 |
|
Hi,
I'm sorry, no Rdb licenses. So, DDD not allowed.
Do Rdb trans. gway to EDA/SQL e
Sybase mean DBI Gtw to EDA/SQL and DBI Gtw to Sybase?
Not having Rdb, what would you suggest?
I know that EDA has a script 'simulating' an replicator like
DDD but not with so many features... Any other choices?
Thanks,
Cristina.
|
| 1072.3 | Not sure what to suggest... | BROKE::ABUGOV | | Thu Jun 20 1996 18:17 | 12 |
|
Hi Cristina,
Yes, the Rdb Transparent Gateways are the new names for the DBI
gateways.
In terms of using a replication product, there seems to be a problem
there. It would work from interactive SQL, but someone would need to
do the programming that causes transfers to happen, etc.
Dan
|
| 1072.4 | | BROKE::PROTEAU | Jean-Claude Proteau | Fri Jun 21 1996 09:10 | 7 |
|
Not that this will help either, but I need to mention it for others who
might be reading this note:
DDD (the Replication Option for Rdb), as an alternative to requiring
Rdb also works if you have Oracle7 (or OracleN) instead plus the
Transparent gateway to Oracle.
|
| 1072.5 | Needing more info... | ORAREP::VAXRIO::NOVELLO | Cristina Novello - Pre-sales/RJ | Fri Jun 21 1996 15:23 | 20 |
| Hi,
in this case to read from a DMS II database and write into a Sybase,
I need the customer needs to buy a Common Components license
to use DBI Gtw for EDA and DBI Gtw for Sybase, right?
(as the customer does not have Rdb).
If he wants to build programs to schedule some 'transfers' using
some language such as Cobol for instance, does he use the SQL
commands of Rdb?
IBI offers an EDA Agent that could be useful to 'transfer' data.
But it doesn't have all features DDD has. If the customer would
like to buy Rdb to use DDD and its features, he could read data
from DMS II and write into a Sybase database, right? Still only
extraction is supported? Replication transfer only supported
if we have Rdb as source databases?
Thanks,
Cristina.
|
| 1072.6 | More answers... | BROKE::ABUGOV | | Fri Jun 21 1996 17:33 | 31 |
|
Hi Cristina,
> in this case to read from a DMS II database and write into a Sybase,
> I need the customer needs to buy a Common Components license
> to use DBI Gtw for EDA and DBI Gtw for Sybase, right?
> (as the customer does not have Rdb).
If the customer buys the gateways, they get use of interactive SQL. If
they want to do sql programming (with module or precompilers) then they
need to buy the tools (I think for Rdb the tools are now called
programmer 2000).
>If he wants to build programs to schedule some 'transfers' using
> some language such as Cobol for instance, does he use the SQL
> commands of Rdb?
Using cobol would require the Rdb cobol pre or module compilers. These
use Rdb SQL. To get these tools, they would need Rdb's programmer 2000
tools
> IBI offers an EDA Agent that could be useful to 'transfer' data.
> But it doesn't have all features DDD has. If the customer would
> like to buy Rdb to use DDD and its features, he could read data
> from DMS II and write into a Sybase database, right? Still only
> extraction is supported? Replication transfer only supported
> if we have Rdb as source databases?
The answers to the questions are "Yes", "Yes", and "Yes"
|