Creating an Aster Execution Engine Connection Profile - Teradata Studio

Teradata Studio User Guide

Product
Teradata Studio
Release Number
16.00
Published
March 2017
Language
English (United States)
Last Update
2018-03-29
dita:mapPath
hop1484765174877.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2041
lifecycle
previous
Product Category
Teradata Tools and Utilities
  1. In the Data Source Explorer or Navigator, click to create a new connection.
  2. From Connection Profile Types, select Aster. To filter the list of databases shown in Connection Profile Types, type a filter key (for example Aster) to reduce the list to a subset of database types that match your filter criteria.
  3. At Name, type a name to identify the connection profile.
  4. [Optional] At Description, type a description of this Connection Profile.
  5. Click Next.
  6. Select Aster Execution Engine (Aster-on-Hadoop) as the type of Aster database, and click Next.
  7. Select a driver from Select a driver from the drop-down. The Aster AX Embedded JDBC Driver template is selected as the default JDBC driver template. If you need to create a new Aster JDBC driver template, click.
  8. [Optional] Check Set Up SSO Connection to create a connection to an SSO-enabled Aster database server.
  9. At Database Server Name, type the host name running the Aster instance.
  10. At User Name, type the user name for the connection.
  11. At Password, type the password for the connection.
  12. Accept the default Port Number or type a different port number.
  13. In Database Name, type the name of the database to which this profile connects. Your connection requires that a default database be set when a user logs on. The default database for Aster Database is beehive.
  14. Select Save Password to save the password. The password is valid for the workbench session.
  15. If you selected Set Up SSO Connection:
    1. Type the KDC required to connect to the database server.
    2. Type the Domain Name required to connect to the database server.
    3. Type the Service Name required to connect to the database server.
    4. Click Browse and add the location of the JAAS Login Configuration file.
  16. In JDBC Connection Properties, accept the default properties or add and remove JDBC connection properties to specify the connection details for the profile.
  17. [Optional] Click Cache Properties to open the Schema Cache Properties dialog and select the schemas to cache.
  18. [Optional] Click Delete Cache Files and confirm to delete cache files.
  19. Specify when to connect:
    Option Description
    Connect when the wizard completes Connect to the Aster instance when you complete the profile.
    Connect every time the workbench is started Connect to the Aster instance each time you launch the workbench.
  20. Click Next to view the Summary information.
  21. Click Finish to create the connection profile.