- Open Teradata Schema Workbench. The database connection status, located in the lower left corner of the main window, displays Not Connected.
- Click . The Connect to database system window appears.
- From the Selection connection pane, select a database. If you do not see anything on the Selection connection pane, be sure you have created a DSN. See Setting Up a Teradata ODBC Data Source.
-
If Teradata Database credentials are not in your DSN, a Database credentials required dialog box appears.
To enter your credentials, follow these steps:
- Select an option from the Authentication Method menu.
-
Do one of the following:
- Enter your username and password.
- Enter a credential string in the Authentication Parameter box.
-
Click OK.
The source database pane populates:
The list of databases that displays excludes standard system databases.By default, all source databases check boxes are selected so tables from different databases can be used for your cube dimensions and those tables can be located during validation.
If your password is not in your DSN and entering your password causes an error, recheck your username and password. Also check the Windows application event log for issues. To access the application log, see Teradata Schema Workbench Event Logging.
You can click Check All or Uncheck All to select or deselect all listed databases, or select only the check boxes of specific source databases.
If you are connecting to a Teradata BI Model Repository that has never been accessed, you will be prompted to set up an MDX Service Account. See Setting Up an MDX Service Account and OLAP Connection.
-
Click OK.
The database connection status, located in the lower left corner of the main window, displays Connected to database system: <Teradata Database name>.
See Setting Up an MDX Service Account and OLAP Connection to set up your service account and password. If your service account has already been set up, proceed to Introduction to the User Interface.