SAP HANA to Databricks Migration

[Anandhu12]

Can we change the connection in a PBI report or dashboard from SAP HANA to Databricks will it work without any issues?

[Datamesh]

Hey,

there is an easy way to migrate data from SAP HANA to Databricks. Our SAP HANA to Databricks connector can help to streamline this process.

The connector enables you to extract data directly from SAP HANA tables and load it iteratively into Databricks for further processing.

The key benefits are:

1. Incremental Data Transfer: Particularly helpful for managing very large datasets.
2. Simple Usage: No complex configurations required.

With the connector, integrating your timestamped data should work seamlessly.

For more details, including implementation steps, please refer to our official documentation. If you need further support, don’t hesitate to contact us at info@dmesh.io.

I hope this helps you integrate SAP HANA data into Databricks!

[rajendraongole1]

Hi @Anandhu12 -while the migration from SAP HANA to Databricks is possible, it involves reworking queries, optimizations, and security considerations. Testing and validation are essential to ensure a smooth transition. Depending on the complexity of the existing SAP HANA setup.In Power BI, navigate to "Transform Data" > "Data Source Settings" and modify the connection details to point to your Databricks cluster instead of SAP HANA.Rebuild Queries: If necessary, update any queries or Power Query transformations that rely on SAP HANA SQL to be compatible with Spark SQL in Databricks.Validate: Ensure that all visuals, filters, and calculations work as expected with the new data source.

reference links:

SAP HANA to Databricks Migration - Microsoft Fabric Community

Integration Options for moving data from SAP into ... - SAP Community

Hope the above information helps.