...
D365 BC Field | DATABASICS Data field |
|
No. | EMPLY_ID | Primary key |
Name | N_FIRST | First Name |
Name | N_LAST | Last Name |
Resource Group | DEPT_CODE | Home Cost Center |
EMAIL1 | Used for login and notifications | |
Employment Date | START_DATE | Used for access control, as well as tenure based logic for leave management if applicable |
Termination Date | END_DATE | Used for access control, as well as foundation for final balance reporting for leave management if applicable |
...
Flat files can be imported into DATABASICS from a dedicated SFTP site: more information here
...
Connecting To Dynamics 365 Business Central / NAV
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 Dynamics 365 Business Central / NAVOData service is located.
User — The name of the user who has rights to access Dynamics 365 Business Central / NAVOData, if your Dynamics 365 Business Central / NAVOData service requires authentication.
Password — The password, if your Dynamics NAVOData service requires authentication.
Note: If you are connecting to Dynamics 365 Business Central, you must enter your Web Service Access Key in the Password field NOT your password.
Company Name — Name of the Dynamics 365 Business Central / NAV Company to access. This field is optional. If left blank, Dynamics 365 Business Central / NAV returns the default company.
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.