Skip to main content
insightsoftware Docs insightsoftware Docs
{%article.title%}
Published:
Was this article helpful?
0 out of 0 found this helpful

Export Angle to EA Format

The 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 Format

  1. In ITMC, go to Angle Exports > Datastores.

  2. Click Add new datastore.

  3. Select Export Angle to EA Format.

  4. Click OK. The Create datastore window appears.

  5. Enter the Datastore name.

  6. 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:

    1. If you select Local Folder or Network Drive Location:

      1. Output Folder : Your input depends on the output location type.
        • Local Folder: Enter the output folder for the export file. Note that the specified location must be a full file path on the Application Server. Make sure to choose a secure location.
        • The expected format is <drive letter>:\<output folder>
        • UNC Path: Enter the UNC (Universal Naming Convention) path of your network drive.
        • The expected format is \\<machine name>\<share name>\<output folder>
      2. Username : Optionally, enter the account name of the network drive user.
      3. Password : Optionally, enter the password of the network drive user.
    2. If you select AWS S3 :

      1. S3 Region : Enter the S3 region where your S3 bucket is located.
      2. S3 Bucket : Enter the name of the S3 bucket where the data will be stored.
      3. Upload Folder : Specify the upload folder name. Your file will be uploaded to this folder. If it does not exist yet, the folder will be created in the specified S3 bucket.
      4. AWS Access Key : Enter the Access Key ID of the user.
      5. AWS Secret Key : Enter the Secret Access Key of the user.
    3. If you select SharePoint :

      1. SharePoint Site Url : Enter the home page URL of your SharePoint site.
      2. The expected format is https://<companyname>.sharepoint.com/sites/<sitename>
      3. Site Subfolder : Enter the subfolder name. Your file will be uploaded to this subfolder, which is created under the Shared documents folder on SharePoint.
      4. Username : Enter the username of the SharePoint user. This user should be excluded from multi-factor authentication and should have Add,View, and Edit permissions on the SharePoint site.
      5. Password : Enter the password of the SharePoint user.
  7. Click Test connection to test if the location is available.

    Note: Note that you can choose to leave the following settings empty and instead enter their specifications in Automation tasks when you schedule the execution.

  8. Insert model timestamp - Specify in which column the model timestamp should be inserted. Use '1' to select the first column, '2' to select the second column, and so forth. Select 'None' if no model timestamp column is required.
  9. Set format - Select a format for the set elements:

    • Id - When Id is selected, the IDs of the set elements will be exported. This option is most useful when the output is used for further automatic processing, like in databases or CSV.
    • Display - When Display is selected, the set elements in the export will be formatted as defined in the AngleDisplay. This means, 'short', 'short (long)' or 'long' column names will be used. This option is most useful when the output is used for direct interpretation, like in Excel or HTML format.
  10. Max rows to export - When exporting data only the specified number of rows will be exported. If the result contains more rows, remaining rows will be skipped. Use value -1 to export all rows.

  11. File name - Name of the file to write the Angle data to. Macros can be used to include the Angle name, Display name and/or timestamp.

  12. Append result - Append result to output table. When checked, the data will be appended to the existing table or file. If the file/table does not yet exist, it will be created. When unchecked, a new file or table will be created on every run. When the file/table already exists, it will be overwritten. Note that when append is disabled, the table will be recreated for every run. Macros can be used to include the Angle name, Display name and/or timestamp.

  13. Number of key fields - Specify the number of key fields in the table schema. '0' means no key fields.

  14. Click Save.

Published:

Export Angle to EA Format

The 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 Format

  1. In ITMC, go to Angle Exports > Datastores.

  2. Click Add new datastore.

  3. Select Export Angle to EA Format.

  4. Click OK. The Create datastore window appears.

  5. Enter the Datastore name.

  6. 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:

    1. If you select Local Folder or Network Drive Location:

      1. Output Folder : Your input depends on the output location type.
        • Local Folder: Enter the output folder for the export file. Note that the specified location must be a full file path on the Application Server. Make sure to choose a secure location.
        • The expected format is <drive letter>:\<output folder>
        • UNC Path: Enter the UNC (Universal Naming Convention) path of your network drive.
        • The expected format is \\<machine name>\<share name>\<output folder>
      2. Username : Optionally, enter the account name of the network drive user.
      3. Password : Optionally, enter the password of the network drive user.
    2. If you select AWS S3 :

      1. S3 Region : Enter the S3 region where your S3 bucket is located.
      2. S3 Bucket : Enter the name of the S3 bucket where the data will be stored.
      3. Upload Folder : Specify the upload folder name. Your file will be uploaded to this folder. If it does not exist yet, the folder will be created in the specified S3 bucket.
      4. AWS Access Key : Enter the Access Key ID of the user.
      5. AWS Secret Key : Enter the Secret Access Key of the user.
    3. If you select SharePoint :

      1. SharePoint Site Url : Enter the home page URL of your SharePoint site.
      2. The expected format is https://<companyname>.sharepoint.com/sites/<sitename>
      3. Site Subfolder : Enter the subfolder name. Your file will be uploaded to this subfolder, which is created under the Shared documents folder on SharePoint.
      4. Username : Enter the username of the SharePoint user. This user should be excluded from multi-factor authentication and should have Add,View, and Edit permissions on the SharePoint site.
      5. Password : Enter the password of the SharePoint user.
  7. Click Test connection to test if the location is available.

    Note: Note that you can choose to leave the following settings empty and instead enter their specifications in Automation tasks when you schedule the execution.

  8. Insert model timestamp - Specify in which column the model timestamp should be inserted. Use '1' to select the first column, '2' to select the second column, and so forth. Select 'None' if no model timestamp column is required.
  9. Set format - Select a format for the set elements:

    • Id - When Id is selected, the IDs of the set elements will be exported. This option is most useful when the output is used for further automatic processing, like in databases or CSV.
    • Display - When Display is selected, the set elements in the export will be formatted as defined in the AngleDisplay. This means, 'short', 'short (long)' or 'long' column names will be used. This option is most useful when the output is used for direct interpretation, like in Excel or HTML format.
  10. Max rows to export - When exporting data only the specified number of rows will be exported. If the result contains more rows, remaining rows will be skipped. Use value -1 to export all rows.

  11. File name - Name of the file to write the Angle data to. Macros can be used to include the Angle name, Display name and/or timestamp.

  12. Append result - Append result to output table. When checked, the data will be appended to the existing table or file. If the file/table does not yet exist, it will be created. When unchecked, a new file or table will be created on every run. When the file/table already exists, it will be overwritten. Note that when append is disabled, the table will be recreated for every run. Macros can be used to include the Angle name, Display name and/or timestamp.

  13. Number of key fields - Specify the number of key fields in the table schema. '0' means no key fields.

  14. Click Save.

For an optimal Community experience, Please view on Desktop
Powered by Zendesk