Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

No changes are made to the on-premises database. The Data Uploader needs Read-only access to the source database on the SQL server to query the database and upload the information to CAM.

...

Connection Strings

What is a Connection String?

A connection string enables the Data Uploader to access your native database to authorize and execute the query request at run time.

The Data Uploader Log tab displays a Connection String error. How to fix this?

This error is displayed if the Connection String is not valid and the Data Uploader cannot access your database. In the Connection String tab, re-enter the credentials, click Save, and Test the connection. A Valid connection message must be displayed.

...

Authentication Errors

Why does the Data Uploader return an Authentication error when I try to run a provisioning job?

This usually occurs if the Authentication token has expired. In the Data Uploader> Authentication tab, enter your password and click Re-Authenticate.

...

Job Upload Fails

The Connection String and the Authentication are validated, why does the Data Uploader fail to upload a job?

In order for Data Uploader to be able to create a Provisioning job, a properly configured script to update the matters must exist in the default SQL folder C:\Program Files(x86)\Prosperoware\DataUploader\SQL or in the folder path displayed in the SQL Files tab.

...

Will DataUploader support Secure LDAP or enforce this as well?

Will this comply with cloudimanage.com’s requirement to have users and groups synced securely?

Data Uploader has two steps to the process. Uploader first locally connects to AD via the LDAP protocol and uploads to CAM over HTTPS (443) and then CAM calls the iManage Rest API over HTTPS (443) to create users and groups. Directly connecting to Secure LDAP is on the future roadmap.

...

Sample CSV for Provisioning Shortcuts

Does anyone have a sample CSV file to provision shortcuts in iManage?

Yes, please find attached a sample CSV for this and modify it for your data: Sample Provisioning CAM CSV

...

Note this does not only apply to an initial job, but any JobDelta run.

...

AD Mapping Issues

The CSV was not generated:

  • Check if any issue with the configuration here, or from the Source Mapping config.

Extra data is imported that shouldn’t be:

...

  • Check the configuration here, or from the Source Mapping config.

Info

To help the latest version of Data Uploader does contain helpful comments in each of the config file of how to configure each part…

For example:

<!--Object property refers to type of entity you want to apply filter.Its required value and needs to be defined .Values : UsersOrGroups,UsersOnly,GroupsOnly -->

...