Overview¶
DATASTAR allows you to mange your static database configuration data as components using a template based approach to define what data makes up a component. At a simple level this could be a parent child relationship where each row in the parent is extracted as an individual component and includes it's related child records. However DATASTAR supports much more complex relationships including resolving primary key references embedded in XML content.
Versioning¶
To obtain the maximum benefit from the software, the generated component scripts should be placed under version control. Once you have connected to a supported version control system you will be able to use features such as clone, commit, view history, merge and diff. It is recommended that when you commit you assign a task tracking reference. DATASTAR currently supports the following Version Control Tools:
- GIT
- TFVC
Task Tracking¶
Task tracking allows you to associate your changes with a task, this is a useful feature as it provides an audit trail of what changes are being made for what purpose. Once the association is created it is then a simple process of generating a deployment file for the required task. DATASTAR currently supports the following Dev Ops Task Management Tools:
- AZURE DEV OPS
- RALLY
- JIRA
Deployment¶
DATASTAR provides a mechanism to package up deployments into a deployment manifest, once this is created it can be integrated into an automated build and deployment lifecycle using tools such as Azure Dev Ops Build and Release pipelines or Octopus Deploy. The deployment also supports the generation of "reversal" scripts, these are generated at the time of deployment to capture component before applying the change, thereby creating a script that can be used to "reverse" any changes made.
Databases¶
DATASTAR extracts data from a source database in a human readable SQL script format, allows you to place it under version control and deploy via automated CI/CD pipelines to manage the release of the data components within a well defined process.
DATASTAR currently supports the following databases:
- Microsoft SQL Server
- Oracle (requires the use of Global Temporary Tables)