Oracle

[Ron0z]

I would like to have SPSS (v22) read data from an Oracle database.  Are there any tips or traps I should know about?

I found some instructions on doing this in “Programming and Data Management for IBM SPSS Statistics 23: A Guide for IBM SPSS Statistics and SAS Users” on p. 12.  The only thing that put me on edge upon reading this was a comment (on p. 13) which said, you must have .NET framework and IBM SPSS Data Collection Survey Reporter Developer Kit.  I had a look at the link for this developer kit, and it seems nothing remotely like I’d want to use. Any ideas as to why the kit might be a “must have” on the instructions?

[Jon K Peck]

All you need for reading from a database is the appropriate ODBC driver.  Then just use the database wizard on the file menu.  The .NET frame and the Data Collection Developer Kit have nothing to do with this.

The full text you found is this.

OLE DB: Starting with release 14.0, some support for OLE DB data sources is provided.

To access OLE DB data sources (available only on Microsoft Windows operating systems), you must have the following items installed:

v .NET framework. To obtain the most recent version of the .NET framework, go to http:// www.microsoft.com/net.

v IBM SPSS Data Collection Survey Reporter Developer Kit. For information on obtaining a compatible version of IBM SPSS Data Collection Survey Reporter Developer Kit, go to www.ibm.com/support.

But you would not be using OLE DB.  Rather, refer to the ODBC material  higher up on that page.

Jon Peck (no "h") aka Kim
Senior Software Engineer, IBM
[hidden email]
phone: [phone]




From:        Ron0z <[hidden email]>
To:        [hidden email]
Date:        10/25/2015 06:56 PM
Subject:        [SPSSX-L] Oracle
Sent by:        "SPSSX(r) Discussion" <[hidden email]>

---

I would like to have SPSS (v22) read data from an Oracle database.  Are there
any tips or traps I should know about?

I found some instructions on doing this in “Programming and Data Management
for IBM SPSS Statistics 23: A Guide for IBM SPSS Statistics and SAS Users”
on p. 12.  The only thing that put me on edge upon reading this was a
comment (on p. 13) which said, you must have .NET framework and IBM SPSS
Data Collection Survey Reporter Developer Kit.  I had a look at the link for
this developer kit, and it seems nothing remotely like I’d want to use. Any
ideas as to why the kit might be a “must have” on the instructions?




--
View this message in context: http://spssx-discussion.1045642.n5.nabble.com/Oracle-tp5730864.html
Sent from the SPSSX Discussion mailing list archive at Nabble.com.

=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD



===================== To manage your subscription to SPSSX-L, send a message to [hidden email] (not to SPSSX-L), with no body text except the command. To leave the list, send the command SIGNOFF SPSSX-L For a list of commands to manage subscriptions, send the command INFO REFCARD

[Albert-Jan Roskam-3]

I recently had an issue where the native Oracle driver often resulted in *mutilated* data. Usually a large number of records were missing, sometimes columns where partially empty. Scary as there was NO error. Sometimes a (time-consuming) ORDER BY resolved the issue. A better fix was to use the Microsoft drivers. I used something like this:




DEFINE !file_dsn () "\\server\share\folder\database.dsn" !ENDDEFINE.

GET DATA

  /TYPE=ODBC

  /CONNECT='FileDSN=' + !file_dsn + ';'

  /SQL="SELECT * FROM tblSomeTable"

  /ASSUMEDSTRWIDTH=255.

CACHE.

EXECUTE.

 

 

# The minimal contents of \\server\share\folder\database.dsn:

[ODBC]
 DRIVER={Microsoft ODBC for Oracle}
 UID=test_user
 PWD=secret
SERVER=MYSERVER




In the Production Facility, a full path is required. CD in conjunction with a FILE HANDLE will not work.

 
regards,

Albert-Jan
________________________________

> Date: Sun, 25 Oct 2015 19:43:56 -0700
> From: [hidden email]
> Subject: Re: [SPSSX-L] Oracle
> To: [hidden email]
>
> All you need for reading from a database is the appropriate ODBC
> driver. Then just use the database wizard on the file menu. The .NET
> frame and the Data Collection Developer Kit have nothing to do with
> this.
>
> The full text you found is this.
>
> OLE DB: Starting with release 14.0, some support for OLE DB data
> sources is provided.
>
> To access OLE DB data sources (available only on Microsoft Windows
> operating systems), you must have the following items installed:
>
> v .NET framework. To obtain the most recent version of the .NET
> framework, go to http://
> www.microsoft.com/net<https://www.microsoft.com/net>.
>
> v IBM SPSS Data Collection Survey Reporter Developer Kit. For
> information on obtaining a compatible version of IBM SPSS Data
> Collection Survey Reporter Developer Kit, go to
> www.ibm.com/support<https://www.ibm.com/support>.
>
> But you would not be using OLE DB. Rather, refer to the ODBC material
> higher up on that page.
>
>
> Jon Peck (no "h") aka Kim
> Senior Software Engineer, IBM
> [hidden email]
> phone: [phone]
>
>
>
>
> From: Ron0z <[hidden email]>
> To: [hidden email]
> Date: 10/25/2015 06:56 PM
> Subject: [SPSSX-L] Oracle
> Sent by: "SPSSX(r) Discussion" <[hidden email]>
> ________________________________
>
>
>
> I would like to have SPSS (v22) read data from an Oracle database. Are there
> any tips or traps I should know about?
>
> I found some instructions on doing this in “Programming and Data Management
> for IBM SPSS Statistics 23: A Guide for IBM SPSS Statistics and SAS Users”
> on p. 12. The only thing that put me on edge upon reading this was a
> comment (on p. 13) which said, you must have .NET framework and IBM SPSS
> Data Collection Survey Reporter Developer Kit. I had a look at the link for
> this developer kit, and it seems nothing remotely like I’d want to use. Any
> ideas as to why the kit might be a “must have” on the instructions?
>
>
>
>
> --
> View this message in context:
> http://spssx-discussion.1045642.n5.nabble.com/Oracle-tp5730864.html 
> Sent from the SPSSX Discussion mailing list archive at Nabble.com.
>
> =====================
> To manage your subscription to SPSSX-L, send a message to
> [hidden email] (not to SPSSX-L), with no body text except the
> command. To leave the list, send the command
> SIGNOFF SPSSX-L
> For a list of commands to manage subscriptions, send the command
> INFO REFCARD
>
>
>
> ===================== To manage your subscription to SPSSX-L, send a
> message to [hidden email]<mailto:[hidden email]>
> (not to SPSSX-L), with no body text except the command. To leave the
> list, send the command SIGNOFF SPSSX-L For a list of commands to manage
> subscriptions, send the command INFO REFCARD      

=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD