insights
2023.10
false
- Release Notes
- Getting Started
- Access and Permissions
- Installation and Upgrade
- Interacting with Insights
- Historical data export
- Logs
- Performance and Scalability
Insights
Last updated Oct 25, 2024
Frequently asked questions
Below are some often asked questions and their answers.
- Can I enable Insights on the cloud tenant first and migrate on-premises data
over later?
- Yes, the cloud tenant doesn't have to be empty. However, we recommend not delaying the migration for too long (2-3 months is fine, 1 year isn't).
- How to get the cloud tenant ID?
- In Automation Cloud, go to Admin and click on the tenant name. You
should see the tenant ID in the URL of the page:
https://cloud.uipath.com/<org name>/portal_/tenant/<tenant ID>
- In Automation Cloud, go to Admin and click on the tenant name. You
should see the tenant ID in the URL of the page:
- How to get the on-premises tenant ID?
- You can look up the tenant ID in the
dbo.Tenantstable.
- You can look up the tenant ID in the
- What kind of Azure SQL connection string we should share to UiPath?
- We're expecting an ADO.NET connection string. This link shows how to
copy the ADO.NET connection string from Azure SQL portal: Connect and query - Azure SQL
Database & Azure SQL Managed Instance. The connection
string should have this format:
Create a DB user with read access and share the username and password with us. Please don't create a password with special characters such as
Server=<your database server url>;Initial Catalog=<your database name>;User ID=<username>;Password=<password>;MultipleActiveResultSets=False;Encrypt=True;TrustServerCertificate=False;Server=<your database server url>;Initial Catalog=<your database name>;User ID=<username>;Password=<password>;MultipleActiveResultSets=False;Encrypt=True;TrustServerCertificate=False;'"`:;/\.
- We're expecting an ADO.NET connection string. This link shows how to
copy the ADO.NET connection string from Azure SQL portal: Connect and query - Azure SQL
Database & Azure SQL Managed Instance. The connection
string should have this format:
- How to test a connection string?
- You can run the
Invoke-Sqlcmdutility in Windows PowerShell. Example:Invoke-Sqlcmd -Query "SELECT TOP 10 name FROM sys.tables;" -ConnectionString "<a connection string you want to test>"Invoke-Sqlcmd -Query "SELECT TOP 10 name FROM sys.tables;" -ConnectionString "<a connection string you want to test>"
- You can run the
- What are the best practices for moving data to Azure SQL?
- If you are using Data Migration Assistant, this document: Best practices for Data Migration
Assistant - SQL Server contains a list of best practices.
Among these practices, we strongly recommend the followings:
- Migrate a server during non-peak times.
- Enable encrypt connections when connecting to the source and target servers.
- If you are using Data Migration Assistant, this document: Best practices for Data Migration
Assistant - SQL Server contains a list of best practices.
Among these practices, we strongly recommend the followings:
- Where does our data go after moving to Azure SQL?
- We will use Azure Data Factory to securely migrate your data from Azure SQL to Snowflake - where our cloud data is hosted. After that, please check whether your dashboards look good and you can take down the Azure SQL instances. We don’t store your data anywhere other than in Snowflake.
- Do we need to add any IP addresses to the allow list?
- As long as you complete step six in the previous section, you don't need to add any IP addresses to the allow list.
- Could you please let me know whether there are any data size migration
restrictions in UiPath Insight cloud?
- There is a data retention policy with Cloud Insights that only carries data for 2 years by default and 5 years for advanced platform sku customers.
- Once migration is completed to the Cloud , all upcoming execution done by
robots’ transactions will be reflected in same historical dashboards/reports in
UiPath Cloud Insight ?
- Yes, they would be reflected in the same historical dashboards
- How long will it take UiPath to finish these processes, and who will be our
point of contact to make sure these are completed?
- It will take up to 2 -3 weeks for the entire process to be completed, but the migration itself will be dependent on the size of the data.
