How to load data from workfront project management application to sql server

Nishi Intwala 1 Reputation point
2022-01-21T21:06:51.42+00:00

How can I retrieve Data from Workfront a project management application to SQL Server ? Any help is appreciated. I found this thread, but it has been archived
https://social.msdn.microsoft.com/Forums/en-US/19d8baef-5d94-4a87-8383-3d4b3b6c7242/loading-data-from-workfront-project-management-application-into-sql-server

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,603 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Ronen Ariely 15,096 Reputation points
    2022-01-24T05:24:40.847+00:00

    Hi,

    (1) I recommend to ask the question in the Workfront forum since it is much more relevant there:

    https://one.workfront.com/s/

    (2) The link you provided include a solution - please elaborate why/if this not fit your needs

    Option 1: export the data to csv -> import to the SQL Server using bcp

    Option 2: use Workfront API and connect Workfront using externalk application which can also connect the SQL Server (C#, vb.Net or any other language/tech).

    https://developer.workfront.com/