At HSBC they do not have a suffient test environment with usable database traffic to properly develop their GBDI workflows and integrate with other tools. They have an exception to use production data on their development environment. Currently they export datamarts on an hourly/daily basis to their GBDI production node.
Now they have a requirement to send datamarts from some collectors to their development environment and production for ongoing dev and UAT. Ideally, they would like to be able export these files to a two servers.
The only option from Guardium (that I can see) is to create duplicate datamarts, and schedule them, increasing the resource utilisation of the collectors.
Using the command below you can setup a failover destination host but not a secondary destinationHost location. It would be nice to be able to export the datamart file to two locations simultaneously using this command.
g11.collector> grdapi datamart_update_copy_file_info --help=true
This command modifies a user-defined and predefined file data mart export.
destinationHost - String - Required. Hostname of target server.
destinationPassword - String - Required. Password for the user specified by destinationUser.
destinationPath - String - Required. Path to location to store the datamart extraction.
destinationPort - String - The port number for the destination.
destinationUser - String - Required. User with write access to the destination path.
failoverDestinationHost - string - If the export to destinationHost fails, then Guardium attempts to export the files to failoverDestinationHost. destinationHost and failoverDestinationHost must have the same credentials and path (destinationPath). The output to get_datamart_info shows the server to which results were last sent.
Name - String - Required. Datamart name
transferMethod - String - Valid values: [SCP, FTP]
validate - Boolean - Valid values: [0 (false), 1 (true)]
withCOMPLETEfile - Boolean - A COMPLETE file is sent after a data file is successfully transferred. Valid values: [0 (false): The marker file is not sent and the data file is prefixed with "DMv2_".
Do not place IBM confidential, company confidential, or personal information into any field.