Template:SQWareCentralPres: Difference between revisions
| Line 51: | Line 51: | ||
*... | *... | ||
[[SQWareCentral:sybase|See the detailed help for sybase]]<br> | [[SQWareCentral:sybase|See the detailed help for sybase]]<br> | ||
<br> | |||
=== mysql === | |||
Centralised actions for mysql<br> | |||
Allows you to perform actions on mysql instances centrally: | |||
*Collection of indicators | |||
*Deploying Scripts | |||
*Repeat of collection of indicators | |||
*... | |||
[[SQWareCentral:mysql|See the detailed help for mysql]]<br> | |||
<br> | <br> | ||
=== mssql === | === mssql === | ||
| Line 61: | Line 70: | ||
[[SQWareCentral:mssql|See the detailed help for mssql]]<br> | [[SQWareCentral:mssql|See the detailed help for mssql]]<br> | ||
<br> | <br> | ||
=== | === mongodb === | ||
Centralised actions for | Centralised actions for mongodb<br> | ||
Allows you to perform actions on | Allows you to perform actions on mongodb instances centrally: | ||
*Collection of indicators | *Collection of indicators | ||
*Deploying Scripts | *Deploying Scripts | ||
*Repeat of collection of indicators | *Repeat of collection of indicators | ||
*... | *... | ||
[[SQWareCentral: | [[SQWareCentral:mongodb|See the detailed help for mongodb]]<br> | ||
<br> | <br> | ||
=== DB2 === | === DB2 === | ||
Revision as of 19:33, 8 August 2015
Presentation
Usage
SQWareCentral™, also known technically as expDbTools®, is the central point of dbSQWare™ for all RDBMS.
Usage examples:
- Central point of ssh connections
- Search of instances, database/schema, ...
- Deployment scripts of SQWareProduction™ for each RDBMS managed
- Collection of indicators for each RDBMS managed
- Repeat of collection for each RDBMS managed
- Execute any type of action on a list
- ...
Download the latest stable versions
Installation guide for SQWareCentral™
Explanation of directories
Directories located in $gvsqw_RootexpdbCentral:
- action : Directory containing specific files for each managed RDBMS
- bin : Directory containing standard scripts
- bin_cust : Directory containing customs scripts for your environnement
- etc : Directory containing the standard files of configuration
- etc_cust : Directory containing the customs files of configuration for your environnement (overload standards)
- help : Directory containing the standard files of help
- help_cust : Directory containing the customs files of help for your environnement
- lib : Directory containing the generic shell function librairies
- lib_cust : Directory containing the generic shell function librairies (overload standards)
- logs : Directory containing logs and temporaries files
- menu : Directory containing the standard menus
- menu_cust : Directory containing the custom menus for your environnement
General architecture diagram SQWareCentral™ (when the SQWareProduction™ module is locally installed)
action
oracle
Centralised actions for oracle
Allows you to perform actions on oracle instances centrally:
- Collection of indicators
- Deploying Scripts
- Repeat of collection of indicators
- ...
See the detailed help for oracle
sybase
Centralised actions for sybase
Allows you to perform actions on sybase instances centrally:
- Collection of indicators
- Deploying Scripts
- Repeat of collection of indicators
- ...
See the detailed help for sybase
mysql
Centralised actions for mysql
Allows you to perform actions on mysql instances centrally:
- Collection of indicators
- Deploying Scripts
- Repeat of collection of indicators
- ...
See the detailed help for mysql
mssql
Centralised actions for mssql
Allows you to perform actions on mssql instances centrally:
- Collection of indicators
- Deploying Scripts
- Repeat of collection of indicators
- ...
See the detailed help for mssql
mongodb
Centralised actions for mongodb
Allows you to perform actions on mongodb instances centrally:
- Collection of indicators
- Deploying Scripts
- Repeat of collection of indicators
- ...
See the detailed help for mongodb
DB2
Centralised actions for DB2
Allows you to perform actions on DB2 instances centrally:
- Collection of indicators
- Deploying Scripts
- Repeat of collection of indicators
- ...
postgres
Centralised actions for PostgreSQL
Allows you to perform actions on postgres instances centrally:
- Collection of indicators
- Deploying Scripts
- Repeat of collection of indicators
- ...
See the detailed help for PostgreSQL
teradata
Centralised actions for Teradata
Allows you to perform actions on teradata instances centrally:
- Collection of indicators
- Deploying Scripts
- Repeat of collection of indicators
- ...
See the detailed help for Teradata
cassandra
Centralised actions for Cassandra
Allows you to perform actions on cassandra instances centrally:
- Collection of indicators
- Deploying Scripts
- Repeat of collection of indicators
- ...
See the detailed help for Cassandra
ingres
Centralised actions for ingres
Allows you to perform actions on ingres instances centrally:
- Collection of indicators
- Deploying Scripts
- Repeat of collection of indicators
- ...