Sometimes you no longer need to retain the information
that was defined for a data source. Perform this task to delete a
data source definition that links Integration
Composer to
the data source.
Before you begin
Note that you cannot delete a data source if it is used
in a mapping. You must first delete the related mapping, as described
in Deleting a mapping.
All
the information for a particular data source, as described in Step 1: Defining your data source connections, can be deleted
from the Integration
Composer repository using
the deleteDataSource command. This information
includes the source name, source user, source password, schema name,
repository password, connection type, and all the other related information
that was defined for the data source.
You
delete a data source by running either the deleteDataSource.bat command
(on Microsoft Windows operating systems),
or the deleteDataSource.sh command (on UNIX-based operating systems).
You run the command from the bin subdirectory
in your Integration
Composer installation
directory.
Before you run the
command, review the following command syntax, option and parameter
definitions, and usage:
| Syntax: |
|
| |
|
|
| |
deleteDataSource |
|
| |
|
help
|
| |
|
listDataSources repositoryPwd
|
| |
|
repositoryPwd sourceName
|
| |
|
|
Options:
|
|
| |
- help
- Displays the command syntax.
- listDataSources
- Displays all data sources that were created in the Integration
Composer repository,
plus their corresponding data schema and mappings. The display format
is:
Data Source: sourceName Data Schema: schemaName Mapping: mappingName
If
a data source has multiple mappings, one data source row is displayed
for each mapping and all rows related to the same data source
are grouped together.
|
| |
|
|
Parameters:
|
|
| |
- repositoryPwd
- The login password for the Integration
Composer repository
(the repository is in the Maximo® database,
so use its password); for example, maximopwd.
- sourceName
- The name for the data source that you are deleting. It can be
a data source for the discovered source data or for the target. For
example, TADDM72 might
represent the discovered source data in Tivoli® Application Dependency Discovery Manager
7.2. (The name is case sensitive.)
|
| |
|
|
Usage:
|
|
| |
- Close Integration
Composer before
issuing the command.
- Windows conventions
are followed for specifying directory names and directory paths. UNIX users should replace each
backslash (\) with a forward slash (/) in any Windows directory paths that include backward
slashes.
- UNIX users must specify ./deleteDataSource.sh as
the command name; Windows users
specify deleteDataSource.
- Issue the command from the bin subdirectory
in your Integration
Composer installation
directory, installation_dir\bin.
- Always type the parameter values for your command in the same
order as they appear in the command syntax.
- Parameter values with one or more spaces must be enclosed in quotation
marks (").
- If you enter an incorrect user ID or password, the
database driver returns an authentication error; for example, the DB2® driver returns: Connection
authorization failure occurred. Reason: User ID or Password invalid.
- If the property mxe.db.user in
the fusion.properties file is commented out or missing, the following
error is displayed: The mxe.db.user property is not set in
the fusion.properties file. Make sure the properties file is configured
correctly.
- If all required arguments are not entered, the command syntax
is displayed.
- If you attempt to delete a data source that does not exist, the
following message is displayed: Data source sourceName does
not exist in the Integration
Composer repository.
- If you attempt to delete a data source already being
used in a mapping, the following message is displayed: Data
source sourceName cannot
be deleted because it is being used in the following mappings: mappingName.
- When you run the command, you will receive a message asking to
confirm the deletion: This action will delete data source sourceName.
If you do not want to delete this data source, press CTRL-C. Press
Enter to continue.
|
The steps for deleting a data source follow.
Procedure
- If Integration
Composer is
open, close the application.
- Open a command prompt.
- Navigate to the bin subdirectory in
your Integration
Composer installation
directory, installation_dir\bin.
- On the command line, type one of the following commands
and add the command options, parameters, and values you want:
| |
Windows: |
deleteDataSource |
| |
UNIX: |
./deleteDataSource.sh |
- Press Enter to run the command. If you receive a confirmation message, press Enter to
continue (or press CTRL-C to cancel the command).
Example
The following command
example (for Windows operating
systems) shows a command that deletes all the information in the Integration
Composer repository
for data source TADDM72:
deleteDataSource
maximopwd TADDM72
On UNIX-based
operating systems, specify ./deleteDataSource.sh instead
of deleteDataSource as the command name.
Successful
command processing yields the following message:
Data
source TADDM72 deleted successfully.