Define Angle Automation tasks
Automation TasksNote:
This functionality is only available if you have sufficient privileges. Your privileges are maintained by your system administrator in the
IT Management Console
.
To create, enable, or disable automation tasks, open the IT Management Console and navigate to Angle exports >Automation tasks.Here you can schedule automated datastores or program/script files to...
Managing Automation Tasks
Managing Automation TasksYou can do the following on automation tasks:Add an Automation taskAdd Actions to TasksCopy a TaskCopy an Action to a TaskExecute a Single Action from a TaskAdding an Automation TaskTo add a new taskClick Add task.The Create task screen appears.Enter the following information:Task fieldsNameTask name.Run as userEnter the username of the user who is the owner of this tas...
Datastores
DatastoresNote:
This functionality is only available if you have sufficient privileges. Your privileges are maintained by your system administrator in the
IT Management Console
.
Datastores are automated exports of data, available in various plugins. The following options are available:Adding a datastoreEditing a datastoreDefine the default CSV or Excel datastoreDeleting a datastoreOpe...
Alert for Angle result
Alert for Angle ResultThe alert for Angle result datastore is used to create email alerts when an Angle is executed. First, create the datastore and subsequently schedule the email in Define Angle Automation tasks.To add a new alertClick Add new datastore.Select Alert for Angle result.Click OK. The Create datastore window appears.Enter the Datastore name.Click Save.
Export Angle to CSV
Export Angle to CSVTo export an Angle to CSVIn ITMC, go to Angle Exports > Datastores.Click Add new datastore.Select Export Angle to CSV.Click OK. The Create datastore window appears.Enter the Datastore name.Select the Save To location. This can be a local folder, AWS S3, a network drive, or SharePoint. Depending on your choice, you are presented with different settings:
If you select
...
Export Angle to EA Format
Export Angle to EA FormatThe EA format defines an Angle as a table. It consists of a zip file containing a .txt and a .xml file. The .xml file contains the definition, and the .txt file contains the data. Together, these files define the Angle as a table. This table can be connected to a model just like other external tables.To export an Angle to EA FormatIn ITMC, go to Angle Exports > Datastor...
Export Angle to Microsoft Excel
Export Angle to Microsoft ExcelTo export an Angle to Microsoft ExcelIn ITMC, go to Angle Exports > Datastores.Click Add new datastore.Select Export Angle to Microsoft Excel.Click OK. The Create datastore window appears.Enter the Datastore name.Select the Save To location. This can be a local folder, AWS S3, a network drive, or SharePoint. Depending on your choice, you are presented with differe...
Export Angle to HTML
Export Angle to HTMLTo export an Angle to HTMLIn ITMC, go to Angle Exports > Datastores.Click Add new datastore.Select Export Angle to HTML.Click OK. The Create datastore window appears.Enter the Datastore name.Select the Save To location. This can be a local folder, AWS S3, a network drive, or SharePoint. Depending on your choice, you are presented with different settings:
If you select
...
Export Angle with ODBC Driver
Export Angle with ODBC DriverThis datastore allows you to export Angles to all major database management systems, including:Microsoft SQL ServerMySQLPostgreSQLOracleMicrosoft ExcelMicrosoft AccessThe database management system needs to be installed on your system. Make sure to install the 64 bit version of the database system. When you export to Microsoft Access, the exported record length cann...
Export Angle to Microsoft SQL server
Export Angle to Microsoft SQL ServerTo export an Angle to a Microsoft SQL serverIn ITMC, go to Angle Exports > Datastores.Click Add new datastore.Select Export Angle to Microsoft SQL server.Click OK.The Create datastore window appears.Enter the Datastore name.Server name - Name of the database server. Use localhost when the database is running on the Application Server. Add instance name when n...
Excel templates
Excel TemplatesExcel templates are used to export data to Excel. You can use the default template or the system, upload your own Excel templates, or download the existing ones, customize them, and upload them again. In order to, for instance, run a specific Process Automation Pack process, you can create an Excel template with that process. Selecting that Excel template when exporting an Angle,...
Export defaults
Export DefaultsThis section describes the export defaults that are available in the Angles for SAPWeb Client. Currently, Export to CSV and to Export to Excel are supported. In this section, you can define which datastore to use, the output folder, the data settings, and the format options for each of these export defaults.Export to CSVNote:
This functionality is only available if you have s...
Using macros
Using MacrosMacros can be used in combination with automation tasks to add additional metadata to the export result. You can use macros directly in the datastore and task definition, as well as in the following config items:Filename (Export to CSV, Excel, and HTML)Sheet name (Export to Excel)Table name (Export to SQL)Email subject (All datastore types)Email message (All datastore types)Availabl...