How to seamlessly upload Bold BI Dashboards between On-Premises and Cloud Tenants
Presently in Bold BI, there is a limitation when uploading the dashboard between on-premises and cloud tenants due to changes in the data source connector provider type. However, you can resolve this issue by adjusting the ProviderType value in the downloaded BBIX file from the cloud or on-premises, and then uploading the dashboard to the desired tenant.
It is recommended that you replace all the ProviderType indicated in the BBIX file.
| Connector | On-Premise | Cloud |
|---|---|---|
| Azure SQL Data Warehouse | 1 | 16 |
| Oracle | 2 | 1 |
| PostgreSQL | 3 | 2 |
| Redshift | 4 | 17 |
| MySQL | 5 | 3 |
| Web | 6 | 4 |
| File | 7 | 5 |
| SalesForce | 8 | 6 |
| MariaDB | 9 | 7 |
| Amazon Aurora MySQL | 10 | 8 |
| Amazon Aurora PostgreSQL | 11 | 9 |
| Google Cloud MySQL | 12 | 10 |
| Google Cloud PostgreSQL | 13 | 11 |
| MemSQL | 14 | 12 |
| MongoDB | 15 | 13 |
| 16 | 14 | |
| AzureDevOps | 17 | 15 |
You are required to adjust the ProviderType for REST and File related sources such as Asana, Google, Web, Csv, Google sheet, JSON, SharePoint, Excel, Dropbox, etc.
No changes in ProviderType are necessary for the connectors listed below:
SQL, Presto, Snowflake, ODBC, SSAS, SqlCe, Amazon RDS SqlServer, Amazon RDS MySQL, Amazon RDS MariaDB, Amazon RDS Amazon Aurora MySQL, Amazon RDS PostgreSQL, Amazon RDS Amazon Aurora PostgreSQL, Amazon RDS Oracle, SQLite, CDATA, Vertica, InfluxDB, SparkSQL, AmazonAthena, Elasticsearch, Clickhouse, AzureDataExplorer, CDATASqlServer, CDATAMySQL, Rockset.
Please follow the steps below to replace the ‘ProviderType’ in the BBIX file:
- Open the downloaded BBIX file in any text editor, for example, Notepad++.
- Replace all the ProviderType values in the BBIX files according to the information provided in the table above.
Find what: "ProviderType\":4
Replace with: "ProviderType\":6
BBIX file
Replace
Once you have replaced the necessary values, you may upload the dashboard to the tenant (cloud to on-premises or vice versa) without any problems.
You will only need to adjust the ProviderType if you are uploading the dashboards between Bold BI cloud and an on-premises tenant. No changes are necessary for uploads between cloud-cloud or on-premises-on-premises.
Additional References
