Data Factory and Project Online

Agnese 6 Reputation points

I need to bring data tables from Project Online to Azure SQL Database.
I would like to use Data Factory for this purpose.
I tried to connect Data Factory to Project Online solely using a Copy Data activity, without success.
I adopted an OData connector, printing on it the Project list link I needed to get data from, but it says I'm not authorized to use it (Failed to create OData connection to RequestUrl Failed to get metadata of odata service, please check if service url and credential is correct and your application has permission to the resource. Activity ID: ///////).
I used AutoIntegrationRunTime
Authentication type: I tried to use both Basic and Windows, because I got to know that the other two authentications require Active Directory (token, ecc.)

--> Did anyone encounter similar issues and have recommendations on how to solve this problem?
--> Does the Activity need to be authorized directly from Project site? If yes, how is this achieved?

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
7,180 questions
{count} vote

1 answer

Sort by: Most helpful
  1. KranthiPakala-MSFT 39,007 Reputation points Microsoft Employee

    Hi @Agnese ,

    Welcome to Microsoft Q&A platform and thanks for your query.

    Unfortunately Project Online is not supported by ADF currently. I would suggest you to please up-vote and/or comment on below feature request suggestion which would help to increase the priority of the feature request.

    ADF User voice forum : Project Online support in ADFv2

    Hope this info helps.


    Thank you

    Please do consider to click on "Accept Answer" and "Up-vote" on the post that helps you, as it will be beneficial to other community members.

    1 person found this answer helpful.