Use a CSV file in the Create Databases wizard to create an
SAP Sybase IQ database on the same host as the SCC
agent.
Prerequisites
| Database Version |
Database Privileges |
|---|
| SAP Sybase IQ 15.3 and 15.4 |
You must have DBA authority. The account under which the server is
running must have write permissions on the directories where files are
created. |
| SAP Sybase IQ
16.0 |
The
account under which the server is running must have write permissions on
the directories where files are created. No other system privilege is
required. |
- The SAP Sybase IQ resource is authenticated and
running.
- A CSV file containing the required database values.
Task
Successful database creation results in a new, running, and registered
SAP Sybase IQ server visible in the resource
perspective.
- In the Perspective Resources view, select the resource, and
select .
- In the left pane, expand , and then select Databases.
- Click the arrow next to Databases and select New.
The Create Databases wizard appears.
- On the Database Definitions page, click Import, specify the
CSV file and path and the file field delimiter and click
OK.
The new database appears in the Data Definitions pane. If your database
definition values are valid, a check mark appears in the Validation column. If any
input for the database definition is invalid, an X appears. Hover the mouse over the
X to see error information. To correct error, select the applicable database
definition and click Edit. See Creating a
Database for details individual properties.
- Once the database definition is deemed valid (check mark appears), click the
Next button.
- On the Execution page, click Execute to start the database
creation process.
- Click Close to exit the Create Database wizard.