Re: Connect to Oracle & ODBC datasource in one SQR

[Joe Johnson <jej1216@HOTMAIL.COM>]

George,

I tried doing just that - I needed to connect to a SQL Server table via ODBC
and write to an Oracle table.

What I have pieced together is this (based on input from various gurus and
PS Customer Support):

The SQRW application is set to one database type: Oracle, ODBC, whatever.

If you try to access a non-Oracle db with the Oracle-based SQRW, the app
freaks out trying to apply Oracle parameters to a non-Oracle db.

I was told that I need to one of the following:

1) create a flat file (using Excel or any method to get a csv or similar
file) from the SQL Server table, and then use an SQR to take that data into
Oracle tables

or

2) install a separate SQRW application that is ODBC-based, use 1 SQR to
extract the data, and then use the Oracle-based SQRW to run an SQR that puts
the data into Oracle.

or

3) create the flat file and use Data Mover to populate the PS records.

I opted for door number 1.

If I am wrong about this interpretation maybe someone in this group can
clarify the issues for me and you.

HTH,

Joe Johnson
PeopleSoft Systems Analyst
joejo@snellingcorp.com
972-776-1332
----- Original Message -----
From: "George Mansoor" <GMansoor@GETTY.EDU>
To: <SQR-USERS@list.iex.net>
Sent: Wednesday, October 04, 2000 12:12 PM
Subject: Connect to Oracle & ODBC datasource in one SQR


> Is this possible w/ SQR 4.3.4?  We have setup a DB connect string as
specified in the documentation but we get an "invalid connect string" error.
Any ideas?
>