Creating an Aster Database Connection Profile - Teradata Studio

Teradata Studio IDE Plug-in User Guide

Product
Teradata Studio
Release Number
15.12
Published
August 2016
Language
English (United States)
Last Update
2018-05-03
dita:mapPath
pts1468860020550.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2043
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 a driver from Select a driver from the drop-down. The Aster Embedded JDBC Driver template is selected as the default JDBC driver template. If you need to create a new Aster JDBC driver template, click .
  7. [Optional] Check Set Up SSO Connection to create a connection to an SSO-enabled Aster database server.
  8. At Database Server Name, type the host name running the Aster Database.
  9. At User Name, type the user name for the connection.
  10. At Password, type the password for the connection.
  11. Accept the default Port Number or type a different port number.
  12. 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.
  13. Select Save Password to save the password. The password is valid for the workbench session.
  14. 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.
  15. In JDBC Connection Properties, accept the default properties or add and remove JDBC connection properties to specify the connection details for the profile.
  16. [Optional] Click Cache Properties to open the Schema Cache Properties dialog and select the schemas to cache.
  17. [Optional] Click Delete Cache Files and confirm to delete cache files.
  18. Specify when to connect :
    Option Description
    Connect when the wizard completes Connect to the database when you complete the profile.
    Connect every time the workbench is started Connect to this database each time you launch the workbench.
  19. Click Next to view the Summary information.
  20. Click Finish to create the connection profile.