This is the scenario for the demo.
- start with 4 empty MS SQL DBs - multi-schema
- TO DO: provide script to setup everything
- install Datical in C:\apps\DaticalDB
- install Electric Cloud agent
- the Datical project is at https://github.com/datical-customersuccess/ECloudIntegrationDemo
- The SQL repo is at https://github.com/datical-customersuccess/ECloudIntegrationDemo_sql
- Create a resource named daticalWindows pointing to the resource where DaticalDB is installed
- Install EC-Admin plugin
- Install EC-Datical plugins available at:
- The code for the Electric Cloud objects (CI procedure, pipeline, applications, ...) is available at https://github.com/lrochette/Datical-Flow_Integration
Note: CI could be skipped for time purpose and simply call the build procedure manually.
The build procedure would have the following steps:
- checkout Datical project
- checkout SQL project
- run packager
- link report to jobDetail page
- check in changes
- create artifact
###Demo
- package table creation
- should fail on a bad type on a columnn
- fix error and re-package
- artifact created
The pipeline will replicate the Datical pipeline minus the REF stage ("managed" by the CI procedure)
the application will contain 1 component "datical" with 2 processes for each Forecast and Deploy