Re: ADSM Database to SQL Database
1999-06-15 19:06:01
Hi Nathan,
Yes, I've toyed with the idea of running an ODBC client on AIX to run queries
against the ADSM database that could then be placed into
an Oracle database for historical tracking purposes. The only free ODBC driver
that I could find was libiodbc at
http://www.openlinsw.com/iodbc but this wouldn't compile out of the box on my
level of AIX at version 2.50, and I don't have the skill set or time
to get it working properly. For a client, I was going to use the Perl ODBC
driver available from CPAN
I'd love to know if you do get it going and find it useful.
Regards
Steve Harris
AIX/Oracle/ADSM Guy
The Wesley Hospital
Brisbane Australia
I'd rather be singing Barbershop Harmony.
"Norrgard, Nathan" <NNorrgard AT LIBERTY-BANK DOT COM> on 06/16/99 01:24:48 AM
Please respond to "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
To: ADSM-L AT VM.MARIST DOT EDU
cc: (bcc: Steve Harris/Wesley)
Subject: ADSM Database to SQL Database
Fax to:
Has anyone ever thought of importing the ADSM database, somehow, into a
separate SQL database to be used for reference? I am thinking of
establishing a database to be a central point for documentation and
information of the status of our ADSM environment, and while discussing
this, it was mentioned that a great deal of this desired information already
resides within ADSM's database. Is there some scripting I could do to
export the ADSM database and then import it to SQL 7.0?
I know this is more than a little vague, and very strange, so forgive me.
Thanks,
Nathan J. Norrgard
PC Systems Administrator
Liberty Bank
860-638-2938 (v)
860-703-2113 (f)
nnorrgard AT liberty-bank DOT com
|
|
|