New ODBC tool for reading and saving to SQL / ORACLE

[Ehud Levitin]

Hi everyone,
As some of you may know, there are two problems in importing data and saving data to SQL / ORACLE.
1. When you open a Data base with a new query using the Database Wizard, SPSS will check in addition to the Tables, all The Synonyms in the DB. If it happens that there are hundreds of them it might take some very long time to see the tables.
2. When you export data from SPSS to the  SQL/ORACLE DB, SPSS is doing a commit after each row. If the file you save has big amount of rows it will take a lot of time to complete the data export, and will use unnecessary server resources .

We at Genius.co.il (IBM business partners) developed an ODBC tool that solves these two problems.
If anyone is interested in the tool, you are welcome to contact us at :  [e-mail]



Tahnk's
Ehud
 
 

[David Marso]

So where is the link to the free download or should we mark this as SPAM?

Ehud Levitin wrote

Hi everyone,
As some of you may know, there are two problems in importing data and saving data to SQL / ORACLE.
1. When you open a Data base with a new query using the Database Wizard, SPSS will check in addition to the Tables, all The Synonyms in the DB. If it happens that there are hundreds of them it might take some very long time to see the tables.
2. When you export data from SPSS to the  SQL/ORACLE DB, SPSS is doing a commit after each row. If the file you save has big amount of rows it will take a lot of time to complete the data export, and will use unnecessary server resources .

We at Genius.co.il (IBM business partners) developed an ODBC tool that solves these two problems.
If anyone is interested in the tool, you are welcome to contact us at :  [e-mail]



Tahnk's
Ehud

[Rick Oliver-3]

The Database Wizard has a checkbox for displaying synonyms. It's checked by default. It can be unchecked with a single mouse click.

Rick Oliver
Senior Information Developer
IBM Business Analytics (SPSS)
E-mail: [hidden email]
Phone: [phone] | T/L: 206-4922

[Ehud Levitin]

Rick Oliver wrote

The Database Wizard has a checkbox for displaying synonyms. It's checked
by default. It can be unchecked with a single mouse click.

Rick Oliver
Senior Information Developer
IBM Business Analytics (SPSS)
E-mail: [hidden email]
Phone: [phone] | T/L: 206-4922

Yes, you can Ignore the synonyms by unchecking the checkbox, but you can do it only after you see the whole list. getting there can take some very long time.
Is there a possibility to change the default so it will be unchecked by default ?

Thank's
Ehud