Using Teradata Studio with Aster Express

Document created by jthuma on Nov 26, 2014Last modified by aster.community.team on Mar 30, 2015
Version 9Show Document
  • View in full screen mode

What is Teradata Studio:

 

Teradata Studio is a client based graphical interface for running queries in Aster Express and other database platforms.  You can also use it for many other database administration capabilies including: setting up users, security groups, and building database objects.  You can use Teradata Studio to build tables, views, and other Aster objects.  You can also run ANSI SQL queries as well as SQL-MR and SQL-GR queries using Teradata Studio.


To Download Teradata Studio:

 

https://downloads.teradata.com/download/tools/teradata-studio

 

Below is an image of Teradata Studio and its user interface:

 

 

1.jpg

1. Install and run Teradata Studio

 

2. Right mouse click on ‘Database Connections’

 

  • Select ‘Aster Database’ from the Connection Profile Types window.
  • Name it ‘Aster Express’
  • Click ‘Next’

 

ncp1.png

 

3. In the Specify a Driver and ‘Connection Details’ enter:


Database Server Name: 192.168.100.100

  • User Name: db_superuser
  • Password: db_superuser
  • Port Number: 2406
  • Database Name: beehive
  • Click ‘Finish’

 

ncp2.png


4.  Running your first query in Aster Express via Teradata Studio

 

  • Connect to Aster Express using Teradata Studio.
  • Cut and paste the following query and enter into the SQL Editor:  SELECT * FROM public.namefind_configure;
  • Click the green arrorw in the upper right section of the SQL Editor.
  • Review the Results
  • Done!

 

Review the following screenshot as a guide.
 
  fqa1.PNG
 
 
 
 
 
 
 

Attachments

    Outcomes