@jeboal wrote "I can imagine coding something up to leverage the QEM REST API - but was hoping someone had conquered this already with perhaps wrapping it all up in a chef script or other mechanism. "
Well, I did something along those lines several years ago when it was still called AEM (Attunity). It helped me automate task promotion from dev to qa to prod and other extensive JSON manipulations in files or 'up in the air on the fly extracting and providing.
It will certainly need tweaks but it may be close to what you want or serve as an example. Tricky parts were JSON formatting as PowerShell json manipulations were not very predictable. Text is sometimes easier.
Anyway, here is the Powershell code from 2017 attached as .TXT fill and the 'help' below.
PS C:\Users\hein.HEINV-LPW10> C:\scripts\AEM_Replicate_JSON.ps1 -help
AEM_Replicate_JSON.ps1 - Hein van den Heuvel - Attunity - 24-Dec-2017
This script is used obtain an overview of tasks and endpoint for a replicate
server through the Attunity Enterprise Manager (AEM) RestAPI or from a provided JSON file.
The script can also be used to EXPORT Replicate Server/Task JSON files with optional tweaks.
For example, when moving defintions from one server to the next, typically the Endpoints
must NOT be carried over as existing endpoint on the targetted server will be used with
a different target database(server) and different credentials.
We also expect that the endpoint name as well as the taskname will need to be
changed according to the naming standards in place to match the new environment.
This scripts can adapt the following elements in a Replication Definition
- Remove Databases section ( Endpoints ) should they exist,
failing to remove could make existing endpoint unoperational on import.
- Sort explicit included tables by owner,name
- Remove original UUID if present.
- Change Task Name
- Adaption of End-Points to provided new source and target names
- Remove Tasks section
- List top-level sections. Typically:
tasks, databases, replication_environment, notifications, error_behavior, scheduler
- Remove specified top-level section
- Add or Replace Explicitly selected tables from CSV file in NAME,OWNER syntax.
Owner will be defaulted from the first usage, or provided on commandline.
IF the switch "Reference" is used, then NO contents change is done.
The purpose of this is to generate a template going through the same
power-shell defined formatting for easy comparisons with tools like WinDiff
Options:
-InputJson Required input file, with single task or full Replication_Definition
or Obtain from Attunity EnterPrise Manager (AEM)
-Credential Object obtained with : Get-Credential -Credential
(or use System.Management.Automation.PSCredential Object)
-AemURL Default https://localhost/attunityenterprisemanager
-RepServer Targetted Replicate Server through AEM. Default: localhost
-RepServer Targetted Replicate Server through AEM. Default: localhost
-UserName To allow script to prompt for PassWord. Default: HEINV-LPW10\hein (should be: user@x.y)
-OutputJson Name of output Json file formatted similar to Replicate, but not exactly the same.
-SourceEP New Name for Source Endpoint (aka "database") IF single task.
-TargetEP New Name for Target Endpoint IF single task.
-TaskName TaskName to act on, if not the first and only task.
-RenameTaskTo New Name for Task IF single task.
-SectionName Name of json section to act on.
-AddTables_CSV_file Name of CSV file with tables to ADD to the current tables in task (name,owner)
-NewTables_CSV_file Name of CSV file with tables to REPLACE the current tables in task with (name,owner)
-EPname + -EPdbsettingName + EPdbsettingValue To change End-point setting like "password"
-- Switches --
-Reference Generate unchanged contents with script specifix formatting for comparisons
-NotSortTables Stop the script from Sorting the explicitly included table list.
-DeleteEP Remove the "databases" section from the InputJson
-DeleteTasks Remove the "tasks" section from the InputJson
-DeleteSection Request removal of json section identified by -SectionName
-Import Import using AEM
-TaskOverview List Tasks in the json file.
-EPOverview List Databases (End Points) section in the json file
-SectionOverview List the sections in the json file, useful as quick verification.
-help This text
