How to connect to Aster database from Statistica ?

How to connect to Aster database from Statistica ?

book

Article ID: KB0074165

calendar_today

Updated On:

Products

Statistica

Description

 User needs to pull in data from Aster database into Statistica for Analysis. This article details the steps involved.
 

Issue/Introduction

How to connect to Aster database from Statistica ?

Resolution

The Teradata Aster ODBC driver/client needs to be installed as a pre-requisite to connecting to the database. Teradata Aster supports ODBC connections and hence requires the user to create a ODBC DSN via Control Panel first.

1. Launch Control Panel >> System and Security >> Administrative Tools >>System DSN tab and click on the Add button.

         

2. Choose the Aster ODBC Driver.

            

3. Enter the relevant server information and credentials to connect to the database.Save the DSN with a name that will associate to the database you are connecting to.

           

4. Within Statistica ( or Enterprise Manager) , create a new database connection. From Statistica desktop, the user may choose File >> External Data >>Query >> Create (Within Enterprise Manager  you may right click on New Database connection) . In the Data Link properties dialog the user should choose "Microsoft OLEDB Provider for ODBC"

   

5. Choose the DSN that was created in Step 3 and enter credentials as required. You may optionally test the connection to ensure the connection details are correct. (In Enterprise Manager, commit the change to Save)

      

6. Name the connection for future connections ( Once a connection is defined, there is no need to re-define the connection every time you connect to the same database. A user may connect to any defined database connection by picking the connection from a list of database connections) .

          

7. On Statistica desktop, you may define the query with the Query window that launches. In Enterprise manager, right click on a folder and click "New Data Configuration" and  pick the database connection created and click on Query Builder.  Define the SQL query by dragging and dropping tables into the right hand frame. ( the user may alternatively type the SQL statement instead of using the query builder). Click on the green triangular play  button to finalize the query. (In Enterprise Manager, click on the commit button to save)

        

Note : Advanced Query builder does not support ODBC connections.

 8. Bring the data back into a spreadsheet. In Enterprise Manager, you would need to click on Explore  button in the data configuration created to bring the data into a spreadsheet.

 

           

             

Additional Information

Legacy Article ID: 213665