Sybase Control Center can manage many SAP Sybase resources. Register your
SAP Sybase IQ server to identify the server and provide its
connection information to Sybase Control Center.
Prerequisites
Ensure that the SAP Sybase IQ server does not have multiple
databases. Sybase Control Center for SAP Sybase IQ supports a
maximum of one database per server.
Task
The Perspective Resources is open by default.
- From the main menu bar, choose .
SCC starts the
Resource Registration Wizard and prompts you
to define the resource:
Title |
Field Names |
Description |
Resource Type
|
Resource name
|
Resource name, type and description.
Use
<localhost>_iqdemo
as the Resource name and identify the
Resource type as an IQ
Server. Description is
optional.
|
Resource type
|
Description
|
Connection Information
|
IQ host name
|
JDBC connection information:
Use <localhost>
as the IQ host name and
2638 as the IQ port
number. Entering the
Database name
(iqdemo.db) is optional.
Note: Sybase Control Center for
SAP Sybase IQ supports a maximum of
one database per SAP Sybase IQ
server.
|
IQ port number
|
Database
|
Authentication Information
|
IQ Username
|
Demo database user name and password.
Use DBA or dba
(case-insensitive) as the IQ Username and
sql (case-sensitive) as the
IQ Password.
|
IQ Password
|
Options
|
Post registration options
|
Choose Add this resource to the current
perspective and (if Resource Explorer is closed)
Open the resource explorer to view this new
resource.
|
- Click Finish.
This step closes the Resource Registration Wizard.
Perspective Resources now lists
<localhost>_iqdemo as an SCC resource.
- On the Perspective Resources dialog, click the
drop-down arrow next to the server name, choose
Authenticate.
- On the Authentication dialog, enter your authentication
information.
For the Quick Start, SCC uses the demo database login as the authentication
credentials. Choose Specify different credentials. Use
DBA or dba (case-insensitive) as the
IQ Username and sql (case-sensitive)
as the IQ Password. Choose Remember these
credentials for future sessions.
- Click OK.