Automic Workload Automation

  • Private Community

  • 1.  How to configure the actions for either backup, restoring or deleting the content for Analytics

    Posted May 04, 2017 10:07 AM

    The following descriptions are examples:

     

    - ) Depending of what should be accomplished there are three different template workflows to choose from when creating a new job via add object.

    - ) For all the following actions you need an agent on the same application Server PostgreSQL was installed on.


  • 2.  How to configure the actions for either backup, restoring or deleting the content for Analytics

    Posted May 04, 2017 10:08 AM

    Information job (Gathers information about number of rows and size of the analytics data store and send notification):


    - ) Add a new object any type again "ANA" in the search field.

    - ) Choose from the given options the template "DATASTORE_INFO Workflow"

    - ) Edit the Workflow and enter in the "Variables & Prompts" | Prompt Sets menu for the PCK.AUTOMIC_ANALYTICS.PRV.PROMPTSET.PSQL the necessary connections options (Path to the psql; Datastore Host/IP; Datastore Port; Datastore username; Datastore password and Datastore database)

    - ) Save the job and execute it.

    - ) In the following Prompt Set in the Request Queue enter the Agent with the Login which is installed on the same application server as the PostgreSQL DB.

    - ) Submit the information.

    - ) In the following Prompt you'll receive as a notification the information about the PostgreSQL DB like:

    ## AE  DATA ##

    Count: 

    Size:

    Min date:

    Max date: 


    ## SLM  DATA ##

    Count:

    Size:

    Min date:

    Max date:

     

    ## ARA DATA ##

    Count:

    Size:

    Min date:

    Max date:



  • 3.  How to configure the actions for either backup, restoring or deleting the content for Analytics

    Posted May 04, 2017 10:11 AM
    Backup and clean-up job (Backup the data and removes it from the data store):

    - ) Add a new object any type again "ANA" in the search field.
    - ) Choose from the given options the template "DATASTORE_BACKUP_AND_REMOVE Workflow"
    - ) Edit the Workflow and enter in the "Variables & Prompts" | Prompt Sets menu for the PCK.AUTOMIC_ANALYTICS.PRV.PROMPTSET.PSQL the necessary connections options (as already described above)
    - ) Edit in this Workflow also the Prompt Set PCK.AUTOMIC_ANALYTICS.PRV.PROMPTSET.DATASTORE_BACKUP and set the Backup Date (everything before this data will be backup and removed) and a path to where the Backup should be stored.
    - ) Save the job and execute it.
    - ) In the following Prompt Set in the Request Queue enter the Agent with the Login which is installed on the same application server as the PostgreSQL DB.
    - ) Submit the information.


  • 4.  How to configure the actions for either backup, restoring or deleting the content for Analytics

    Posted May 04, 2017 10:12 AM
    Restore Backup (Restores a previously created backup)

    - ) Add a new object any type again "ANA" in the search field.
    - ) Choose from the given options the template "DATASTORE_BACKUP_AND_REMOVE Workflow"
    - ) Edit the Workflow and enter in the "Variables & Prompts" | Prompt Sets menu for the PCK.AUTOMIC_ANALYTICS.PRV.PROMPTSET.PSQL the necessary connections options (as already described above)
    - ) Save the job and execute it.
    - ) In the following Prompt Set in the Request Queue enter the Agent with the Login which is installed on the same application server as the PostgreSQL DB.
    - ) Enter in the second Prompt Set in the Request Queue the backup you like to restore.

    After submitting all the information the data is restored in the database. It will add the missing information into the DB without overwriting already existing information.


  • 5.  How to configure the actions for either backup, restoring or deleting the content for Analytics

    Posted May 04, 2017 10:16 AM
    See also Original Post: https://community.automic.com/discussion/9589