A banking client’s process for extracting data from its automated production environment required teams to code SQL statements in either Java, Scala or Python. This was time-consuming, and the bank required an easier method to access data. While the bank’s architecture did not allow for Fraxses to be deployed in the production environment itself, as would be the case with a standard implementation, it was possible to leverage the power of Fraxses in a different way: by extracting Data Objects as SQL statements and running these against Databricks. This solution required no coding and presented the bank with the solution it was looking for.
The same method can be applied to generate SQL statements for other platforms that utilise Spark, and Fraxses’ capability to generate statements in the relevant SQL syntax can be easily extended for other engines.
To find out more, watch our video.