| Table of Contents | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|
|
What is Data Uploader?
Data Uploader is a CAM windows utility to that read workspaces, users, and groups-related data from your on-premises billing or NBI system and upload the information to the CAM cloud for processing.
...
The Data Uploader can be downloaded from the Administration tab >Data Uploader. Download and run the installer. Read here for Configuration details. The user must have system permission to download, install, and to run the Data Uploader on the Desktop or server.
...
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.
...
This error is displayed if the Connection String is not valid and the Data Uploader could not 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.
...
If there are multiple sources, users can set multiple connection strings. For this to work, .Net 4.6.1 or higher is required to be on the system that data uploader is installed on. The setup of the multiple connection strings , differs where the source systems reside. Use one of the following steps below:
...
Both sources are on-premise and on the same sql SQL server: The connection string can be used for both systems , since the databases reside on the same server.
Both sources are on-premise, but each source is on a different sql SQL server: Data Uploader would need to be installed on two instances, one for each source.
...
Why is Data Uploader blank after I login log in to it?
The ports or sites used in Cloud Uploader are blocked or your .Net version is not .net 4.8+. Add them to Trusted Sites. See the article here.
...
Is there a way to include and reference a timestamp of the time the SQL queries were last run (the feature apparently exists in BillingToMilan)? Currently, their scripts are picking up anything modified in the last x days, but the scripts are run every few minutes, so an almost identical set of results are being uploaded and processed every few minutes. Is there a better way to do this?
...
In order to fix this Login failed issue, we need to change the “App client id” in Cognito Federated Identities within the AWS portal.
Login to the AWS console.
Search for Cognito Service.
Click on “Manage User Pools”.
...