Hi All,
This seems to have gotten busy over the weekend, two questions to
answer;
1) What is the Gateway, how does it sit on the systems.
2) Performance.
Well the gateway runs on a HP3000, it is a gateway to Image/SQL and
Allbase.
It can access/update data in TurboImage databases via Image/SQL. The
Gateway
provides an Oracle listener and Sql*Net V2 network layer, enabling any
Oracle
7 or 8 database on any platform to read/write Image/SQL and Allbase.
So ANY platform that can run the Oracle Server and Sql*Net V2 can
connect to
your Image/SQL and Allbase databases (if you allow it).
Note: The gateway makes Image/SQL and Allbase databases available to an
Oracle Server via a database link, the opposite possibility is covered
shortly.
Performance of the 'gateway' is not really a question, if you understood
the above
description. The gateway acts as an agent between the Oracle Server
(which could
be on almost any system) and Image/SQL or Allbase. If you access
TurboImage
databases, you have to take into account the performance of Image/SQL,
and how
you want to manage Image/SQL's locking of TurboImage datasets.
Any performance queries are Image/SQL or application ones rather than
the gateway.
The same considerations of database links between Oracle databases need
to be
applied to database links to the gateway, and most 'performance'
problems are
due to bad locking or bad code (e.g. un-necessary full table scans).
So far we have discussed how an Oracle database can manipulate data in
an
Image/SQL or Allbase database, if you want to do this the other way
around,
i.e. have a program, say in Cobol, access TurboImage and read/update
Oracle,
this can be accomplished using the Oracle pre-compilers. You can
write/modify
your own code to read/update Oracle databases using embedded SQL. In
this
manner, you can call Image intrinsics as normal, and also connect to
Oracle,
all within your normal environment.
Should you be really keen, there is the Oracle Call Interface, which
provides
subroutine level access to Oracle, but most customers prefer leaving
this to
the pre-compiler.
Hopefully this will help understanding, I don't intend to plug these
products, I
support them, I don't sell them. Questions were asked, answers are
enclosed.
Any specific questions, contact Oracle Support as normal, any general
questions
try me.
I cannot answer direct customers queries that should be routed through
support,
we have procedures in place to handle accountability and quality and are
ISO9000 certified. Personal replies to support questions violate these
systems
and are not official Oracle communications, so log a support call, or
contact
pre-sales.
--
Best Regards,
Vince.
=======================================================================
Vince Martyn
Technical Support Consultant
Oracle Corporation UK
The Oracle Centre
The Ring
Bracknell __ __ _ __ __
Berkshire (__)|-< /-\(__ |__(-_
RG12 1BW. [log in to unmask]
----------
Yes, PowerHouse 8.19C or later (OK, 8.09 or later if we're
going to be totally accurate) can access ORACLE databases
regardless of where they reside. PowerHouse uses the ORACLE
Call Interface (OCI) and so makes use of SQL*Net to access
remote ORACLE databases.
All you will need is SQL*Net installed on the same machine
as PowerHouse and a DATABASE statement in your PDL data
dictionary letting PowerHouse know what the open name
(TNSNAME) for your ORACLE database is.
Best regards,
Conrad
Conrad Whittall
Marketing Manager, Application Development Tools
Cognos Incorporated
Developer productivity never goes out of style!
For details of the Cognos PowerHouse family of high-productivity
development tools for Web, Windows and terminal-based business
applications on the HP 3000 just click here,
http://www.cognos.com/hp3000.
> ----------
> From: Ted Johnson[SMTP:[log in to unmask]]
> Reply To: Ted Johnson
> Sent: Tuesday, December 07, 1999 8:56 PM
> To: [log in to unmask]
> Subject: Connection to Oracle from IMAGE
>
> We are in the process of moving our financial system off the HP3000 onto an
> Oracle NT system (Peoplesoft). However we are planning on keeping our main
> name/address database (for student records, alumni..etc) on the 3000. We
> would like to be able to do "live" updates to either name/address database
> from either system. We have looked at Convoy but it doesn't really appear
> to meet our needs.
>
> TIA,
>
> Ted
> **********************************************************
> Ted Johnson
> Information Systems
> Wake Forest University
> 336-758-4374
> **********************************************************
> I used to listen to the voices in my head, but people told
> me they don't exist....so now I just ignore them.
>
|
