Microsoft Project
Microsoft Project
Follow these steps to connect Microsoft Project to your CData Connect Cloud account:
-
Open the Connections page of the CData Connect Cloud dashboard.
-
Click + Add Connection in the upper-right corner.
-
Type Microsoft Project into the search field, then click the data source name.
-
On the Basic Settings tab of the new connection, enter a connection name or keep the default name.
-
Enter the URL for your Microsoft Project Web App (for example,
https://MyOrganization.sharepoint.com/sites/pwa/
). -
Select the Authentication method, then proceed to the relevant section and follow those instructions.
SharePointOnlineCookies
-
Enter the Microsoft Project username for authentication in the User field.
-
Enter the user password in the Password field.
-
Select a Schema from the drop down. ODataV1 includes more granular data, while ODataV2 can be used for full CRUD operations.
-
(Optional) Enter the default Project Id name to define it for all operations which require one.
-
At the top of the CData Connect Cloud Add Microsoft Project Connection page, click Save & Test.
-
If the connection test succeeds, a message indicates that your connection has been created.
-
If the connection test fails, ensure that you entered your login information correctly with no stray spaces or other characters. Then, try again.
-
OAuth
-
Enter the OAuth Client Id assigned when you registered your Microsoft Project account for OAuth.
-
Enter the OAuth Client Secret for your Microsoft Project account for OAuth.
-
Select a Schema from the drop down. ODataV1 includes more granular data, while ODataV2 can be used for full CRUD operations.
-
(Optional) Enter the default Project Id name to define it for all operations which require one.
-
At the top of the CData Connect Cloud Add Microsoft Project Connection page, click Save & Test.
-
If the connection test succeeds, a message indicates that your connection has been created.
-
If the connection test fails, ensure that you entered your login information correctly with no stray spaces or other characters. Then, try again.
-
ADFS
-
Enter the ADFS User Id.
-
Add the Password for that account.
-
Set the SSO Login URL to the URL used by the SSO provider.
-
Select a Schema from the drop down. ODataV1 includes more granular data, while ODataV2 can be used for full CRUD operations.
-
(Optional) Enter the default Project Id name to define it for all operations which require one.
-
At the top of the CData Connect Cloud Add Microsoft Project Connection page, click Save & Test.
-
If the connection test succeeds, a message indicates that your connection has been created.
-
If the connection test fails, ensure that you entered your login information correctly with no stray spaces or other characters. Then, try again.
-
OKTA
-
Enter the Microsoft Project username for authentication in the User field.
-
Enter the user password in the Password field.
-
Enter the SSO Login URL.
-
Enter all relevant SSO Properties, with the format ‘ssoproperty1=value1;sooproperty2=value2;sooproperty3=value3;’. Make sure to separate all property-value pairs with semicolons.
-
Select a Schema from the drop down. ODataV1 includes more granular data, while ODataV2 can be used for full CRUD operations.
-
(Optional) Enter the default Project Id name to define it for all operations which require one.
-
At the top of the CData Connect Cloud Add Microsoft Project Connection page, click Save & Test.
-
If the connection test succeeds, a message indicates that your connection has been created.
-
If the connection test fails, ensure that you entered your login information correctly with no stray spaces or other characters. Then, try again.
-
OneLogin
-
Enter the Microsoft Project username for authentication in the User field.
-
Enter the user password in the Password field.
-
Enter all relevant SSO Properties, with the format ‘ssoproperty1=value1;sooproperty2=value2;sooproperty3=value3;’. Make sure to separate all property-value pairs with semicolons.
-
Select a Schema from the drop down. ODataV1 includes more granular data, while ODataV2 can be used for full CRUD operations.
-
(Optional) Enter the default Project Id name to define it for all operations which require one.
-
At the top of the CData Connect Cloud Add Microsoft Project Connection page, click Save & Test.
-
If the connection test succeeds, a message indicates that your connection has been created.
-
If the connection test fails, ensure that you entered your login information correctly with no stray spaces or other characters. Then, try again.
-
AzureAD
-
Enter the Azure Tenant Id that you will use to access data.
-
Enter all relevant SSO Properties, with the format ‘ssoproperty1=value1;sooproperty2=value2;sooproperty3=value3;’. Make sure to separate all property-value pairs with semicolons.
-
Enter your OAuth Client Id.
-
Enter your OAuth Client Secret.
-
Select a Schema from the drop down. ODataV1 includes more granular data, while ODataV2 can be used for full CRUD operations.
-
(Optional) Enter the default Project Id name to define it for all operations which require one.
-
At the top of the CData Connect Cloud Add Microsoft Project Connection page, click Save & Test.
-
If the connection test succeeds, a message indicates that your connection has been created.
-
If the connection test fails, ensure that you entered your login information correctly with no stray spaces or other characters. Then, try again.
-
More Information
For more information about interactions between CData Connect Cloud and Microsoft Project, see this information page.