How to pull data from Teradata into Statistica via ODBC
Article ID: KB0082219
Updated On:
| Products | Versions |
|---|---|
| Spotfire Statistica | 10 and later versions |
Description
User needs to pull in data from Teradata into Statistica for Analysis. This article details the steps involved. PREREQUISITES: 1.In addition to the Statistica installation, Teradata ODBC driver must be downloaded and installed . 2. In context of using Statistica Enterprise Manager, the user should have permissions to create a database connection - Either System Admin (SADM) or Database Admin (EXTDB_ADM) and Data Admin (DADM) 3. Details of Teradata server and user credentials.
Issue/Introduction
How to connect to Teradata database from Statistica with Teradata ODBC driver
Resolution
1. Launch Control Panel >> System and Security >> Administrative Tools >>System DSN tab and click on the Add button.
2. Choose Teradata Database ODBC Driver (If this driver is not listed, contact your system administrator). Click Finish
3. Name the data source appropriately and enter the name/IP address if the Teradata server along with username and password details. Click on Test ... button to see if the connection succeeds. If the connection fails, contact your database administrator. Enter details of your default database.
4. Click on Ok. Click either Yes or No on the Teradata warning for storing password depending on the security level in your organization. Click on Ok again to close the ODBC Data Sources dialog.
5. Within Statistica ( or Enterprise Manager) , create a new OLEDB database connection. From Statistica desktop, the user may choose File >> External Data >>Query >> Create (Within Enterprise Manager you may right click on Database connections and click on New Database connection) .
6. In the Data Link properties dialog the user should choose "Microsoft OLEDB Provider for ODBC". Click Next
7. Choose the DSN created in Step 4. Enter Username , Password, enable the option "allow saving password" and enter the database name and click Test connection to ensure that the information is correct.
8. If test connection succeeds, click on OK twice to close the Data Link Properties dialog. Name the connection, define Access permissions and then click on Commit on the top left hand corner of the Enterprise Manager. Enter Audit log information, if prompted. Note that from within Statistica, once database connection has been named, Statistica will automatically bring up SQL wizard
9. Expand System View and choose a folder. Right click on the folder and select New Data Configuration
10. Name the database configuration, choose the database connection previously defined and then click on New next to the Queries button.
11. Type out the SQL Statement or use the SQL Wizard to build the SQL statement. Click on Evaluate SQL to parse the SQL and then click on Next Step/ Commit to define Access Permissions for the data configuration.
12. Click on Commit to save the data configuration. Click on Explore on the data configuration to bring data back into Statistica for further analyses.
2. Choose Teradata Database ODBC Driver (If this driver is not listed, contact your system administrator). Click Finish
3. Name the data source appropriately and enter the name/IP address if the Teradata server along with username and password details. Click on Test ... button to see if the connection succeeds. If the connection fails, contact your database administrator. Enter details of your default database.
4. Click on Ok. Click either Yes or No on the Teradata warning for storing password depending on the security level in your organization. Click on Ok again to close the ODBC Data Sources dialog.
5. Within Statistica ( or Enterprise Manager) , create a new OLEDB database connection. From Statistica desktop, the user may choose File >> External Data >>Query >> Create (Within Enterprise Manager you may right click on Database connections and click on New Database connection) .
6. In the Data Link properties dialog the user should choose "Microsoft OLEDB Provider for ODBC". Click Next
7. Choose the DSN created in Step 4. Enter Username , Password, enable the option "allow saving password" and enter the database name and click Test connection to ensure that the information is correct.
8. If test connection succeeds, click on OK twice to close the Data Link Properties dialog. Name the connection, define Access permissions and then click on Commit on the top left hand corner of the Enterprise Manager. Enter Audit log information, if prompted. Note that from within Statistica, once database connection has been named, Statistica will automatically bring up SQL wizard
9. Expand System View and choose a folder. Right click on the folder and select New Data Configuration
10. Name the database configuration, choose the database connection previously defined and then click on New next to the Queries button.
11. Type out the SQL Statement or use the SQL Wizard to build the SQL statement. Click on Evaluate SQL to parse the SQL and then click on Next Step/ Commit to define Access Permissions for the data configuration.
12. Click on Commit to save the data configuration. Click on Explore on the data configuration to bring data back into Statistica for further analyses.
Feedback
Yes
No
Powered by
