This tool is ONLY available when using CAST Imaging installed on Microsoft Windows using the traditional installer (i.e. not supported when running CAST Imaging on Docker).
|CAST Storage Service/PostgreSQL||The machine on which you are running this extraction must have local or network access to the CAST Storage Service/PostgreSQL where the required data is stored.|
|Number of Applications per Analysis Service schema|
At the current time, it is only possible to extract data from an Analysis Service which contains one single Application, however it is possible to run multiple export actions against multiple Analysis Service schemas to generate data for multiple Applications. This will result in multiple CSV output files which can all be referenced during the import action.
How does it work?
The export process is run with the CLI tool exporter.exe. This tool is installed with CAST Imaging and can be found in the following location:
Execute the below command line to see all the available arguments:
Click to enlarge
Step 1 - run the export
To generate the CSV data ZIP, run the following command either direct in a Command Prompt or via a batch file, changing it to suit your own environment:
-h / --help
|Displays the help message.|
Show program's version number and exit.
|--host||Enter the network host name of the server on which the CAST Storage Service/PostgreSQL is located. Default = localhost.|
|--user||Enter the CAST Storage Service user login. Default = operator.|
|--password||Enter the CAST Storage Service password corresponding to the user entered in --user. Default = CastAIP.|
Enter the port number for the target CAST Storage Service/PostgreSQL. Default = 2282 (CAST Storage Service 3):
CAST recommends using --mngt instead of --schema. Please use one or the other. --schema will eventually be phased out in favour of --mngt.
Enter the name of the Analysis schema schema containing the Application you would like to work with in CAST Imaging.
You can view the name of the Analysis Service schema as follows:
Available in ≥ 2.1.0-funcrel.
This option allows you to specify a specific CAST Storage Service/PostgreSQL database name other than the default "postgres". In the vast majority of situations, this option is not required. It is only necessary if the CAST AIP schemas as stored on the CAST Storage Service/PostgreSQL instance in a database other than the default "postgres". For example:
Available in ≥ 2.0.0-beta6.
CAST recommends using --mngt instead of --schema. Please use one or the other.
Enter the name of the Management schema (i.e. the combined installation) containing the Analysis schema in which the Application you would like to work with in CAST Imaging is stored.
You can view the name of the Management schema as follows:
|--outputdir||Enter the location where the resulting output ZIP will be stored. This folder must exist.|
|--log||Enter the location for the output log file. This file must exist.|
Print debug messages (default: false).
Control check files: yes|no (default:NO).
Regeneration of config files: yes|no (default:NO).
Force the extraction of AIP tables: yes|no (default:NO).
Available in ≥ 2.1.0-funcrel.
|This option will perform a truncated export of application data (i.e. not all the application data is exported) in order to improve the time needed to show results in CAST Imaging. This option is therefore aimed at POC, demos etc. where results need to be produced quickly. It should not be used in production environments.|
Available in ≥ 2.1.0-funcrel.
This option allows you to specify the name of the Application for display purposes in CAST Imaging. For example:
If so, use the following syntax:
--applicationname will accept the following characters only:
Any error related to process and also if required parameter is empty.
Give either --mngt parameter or --schema parameter. Don't give both.
Missing --mngt or --schema parameter. Mention any of these parameter.
Check your connection details. Mentioned management schema does not exist / No local schema associated with this management schema.
Mentioned management schema is not valid.
There are multiple applications under same local schema.
No application found in local schema. Nothing to extract.
Step 2 - Check the results
Assuming the extraction process is successful, the data will be extracted to multiple .CSV files which will be automatically zipped to a ZIP file stored in the location defined in --outputdir. The ZIP file will be named with the name of the Application that has been extracted (MEUDON in the example below):
This ZIP will need to be uploaded to the Application Management portal in CAST Imaging as part of the data import action.
- If you have run multiple export actions to export data for multiple Applications, you will now have multiple ZIP files.
- You can include multiple Application data in one ZIP file for the data import action. In other words, if you have run multiple export actions to export data for multiple Applications, you will now have multiple ZIP files - if necessary, the content of the multiple ZIP files (not the ZIP files themselves) can be included in one single ZIP for the data import action. If you do this, there are no constraints on the name of the ZIP file.
[WinError 10054] An existing connection was forcibly closed by the remote host
If you are attempting to export from a PostgreSQL instance installed on Microsoft Windows (i.e. CAST Storage Service) and your application is very large, you may find that the export process fails with the error which is caused by a timeout:
By default, on PostgreSQL instances installed on Microsoft Windows, the PostgreSQL instance timeout is set to 2hrs, therefore any export process that takes longer than 2hrs will fail. If you encounter this error, it is possible to modify the timeout setting using the postgresql.conf file located here:
Edit this file with a text editor and find the
By default, this entry is commented out and will be ignored - this means that the default value of 0 applies - i.e. the Microsoft Windows system default of 2hrs. To set a longer timeout interval, uncomment the entry and set required interval in seconds (above 2hrs). For example to set a timeout of 6hrs:
Save the file and then restart the CAST Storage Service instance to apply the change.
Note that tcp_keepalives_idle is ignored when the PostgreSQL instance is installed on Linux.
Please see Import the CSV data for more information about the next step.