...
Employee ID
Vendor ID
Employee First and Last Name
Home Company
Employee Type - supporting entry validation (e.g. OT) if included
Default Labor Category / Class
Email address
Manager ID - supporting approval requirements if included
Hire Date
Termination Date
...
Customer
Job / Project
Task
Work Order
Global / Custom Dimensions
Bill Rate - supporting billing, if included
The dimensions utilized, in turn may have attributes and properties supporting customer’s specific requirements that can also form part of the DATABASICS data set, including:
Project / Task Type
Owning Company
Resource Assignment
Assigned Labor Category / Class
Manager ID - supporting approval requirements if included
Start Date
End Date
...
Select Connections from the menu.
From the Connections page select Create to open the Create a connection dialog.
Select the Connector from the list to open the Connection dialog, and then enter the following information for this Connection:
Name — This can be any meaningful name, up to 25 characters.
Alias — An alias for this Connection name. The alias is generated from the Connection name, and can be up to 25 characters. The Connection alias can include letters, numbers, and underscores. Spaces and special characters are not accepted. You can change the alias. For more information, see Connection Alias.
OData Service URL — The address of any acceptable URL where the OData service is located. This URL must end in /data.
User — The name of the user who has rights to access OData, if your OData service requires authentication. Required.
Password — The password for User, if your OData service requires authentication. For more information on OData, see your endpoint provider. Required.
Client ID — GUID that identifies the client in the Dynamics 365 Finance system. This is the Application ID generated when registering the application in Azure Active Directory. Required.
Authentication URL — The URL where the Client ID is verified in following the format. Required.
http://login.microsoftonline.com/[domain_name]
Company Name — The company specified in Dynamics 365 Finance for this integration. Required.
Select Test to ensure that the agent can connect to your database. Be sure to test the Connection against all agents that use this Connection.
Select OK to save the Connection.
...