The ATP (Apptio Targetprocess) – ADM (Automated Data Management) integration helps the customers to exchange data between Targetprocess and other Apptio products, such as Apptio One, via ADM data sharing.   

Users have options to import the data to ATP either from ADM storage or from a local CSV file. The solution enables importing complex data containing relations between entities, dependencies, assignments, create and update existing data.  Users have options to export data from ATP to a local file or to ADM directly. The contents of export are specified via flexible query language. 

How to enable CSV Import/Export on your account

1. To enable the feature on your account turn on the following toggles:
   csvImportExport - to enable the CSV import/export with the local CSV file
   csvImportExport:ADMIntegration - to enable the CSV import/export via Automated Data Management (ADM). Note: csvImportExport toggle must be turned on. This works only on AWS clusters with VPC access.
2. To enable ADM integration, you must generate Frontdoor public key and Frontdoor secret key. To do that:
   • Login to your Frontdoor account: https://frontdoor.apptio.com/and generate both of them on user account under the section  
   • Enter a name for your token, set expiration if required, and select Add
   • The new token is created for your user. Copy Public and Secret keys and paste them into the corresponding fields in your Targetprocess integration profile. Ensure that Apptio Targetprocess and Data Sharing (ADM) are in the same Frontdoor environment:
     
3. When provisioning happens (setting up two systems in one FD environment), file a Task ticket in JIRA under the DOS project with details on the FD environment and region. It'll be handled within 1 business day.

Export data to CSV file or ADM

The export option is found in Setting>>Integration on the left navigation in the connection section. Note: you need Admin rights to access this section. 

1. Select the existing CSV export profile to edit or select + to create a new one. You can change the name of the Integration profile.
2. Type in the data set name and query which contains all the data you want to export. The dataset name will be assigned to the results of the export query in ADM. See ATP API documentation to learn more about all the data needed to create the query.
3. Choose the delimiter from the dropdown list and choose whether you want to download a CSV file or sync data with ADM.

Import CSV file

Import option is found in Settings>>Integration on the left navigation in the connection section. Note: you need Admin rights to access this section. 

1. Click existing CSV import profile to edit or click + Add to create new one. Once new profile is created you should change the profile name.

Import CSV file from local storage to ATP

1. Choose delimiter (must be the same as in the imported CSV file), date format and source: Local CSV file. The available date formats are displayed in the dropdown list.
2. Select Save.
3. File is uploaded. Now, go to Mappings (left menu) and fill the field with JSON file. When the JSON mapping is ready, select Import to import data to ATP.

Import CSV file from ADM to ATP

1. Choose delimiter (must be the same as in the imported CSV file), date format and source (ADM Dataset). Select the dataset you want to import from the dropdown list named ADM dataset.
2. To check the content of the chosen dataset, select the arrow on the right side of the dropdown list. The file with data will be downloaded to your local storage.
3. Select Save.
4. Now, go to Mappings(left menu) and fill the field with JSON file. When the JSON mapping is ready, select Import to import data to ATP.

Cancel import

1. Select Stop Import.Note: Canceling import will result in importing all the batches of records that were processed by the system until the moment of selecting the button. Information about the processed rows is available in the logs section. Resuming the import of the same CSV file is not possible for now.

Statuses

Import/Export failed: Zero or only part of the data is processed

Import/Export completed: All the data (records) is read and processed by the system. However, it does not mean that all of them are imported/exported, since the system can ignore some records. You can check the details in the logs. Not imported/exported data is listed as Warnings.