Contact us for more information
Workfront ETLFeatures | The Problem | Preview
Thinking about backing up or having a copy of your Workfront data for historical, trend analysis or auditing purposes or just for disaster recovery setup purposes?
Aurotech’s Workfront ETL does exactly that. It takes data out of your Workfront instance and houses a copy within your organization’s database. The database can be any relational database like Oracle, MySQL, MS SQL or a custom database like Teradata. Once exported, the Workfront data can be made available to other systems in your organizations for trend analysis, detailed reporting, etc.
The setup is straightforward, gives you the ability to define parameters like frequency, type of load, etc. and takes only 30-45 minutes to setup and then product is ready to use.
The objects that can be copied are Portfolios, Programs, Projects, Tasks, Issues, Users, Hours, Assignments, Baselines and Baseline Tasks and all available details including custom data fields for each of these objects is copied into your database.
Data from Workfront goes into a database using the API field names as the column names.