Our team migrated the client’s ETL process from IBM DataStage to Visual Flow ETL. ETL pipelines were design to collects employees data from learning and development activities such as trainings, seminars, projects, certificates, and other reference information. Data was stored in number of sources such as PostgreSQL, Redmine, and OpenOlat. The overall amount of processed data is several millions of lines per day.
Then the ETL Developer transforms the data and loads it into a local data mart based on the star schema. The migration to Visual Flow allowed them to significantly reduce maintenance costs.
During the development process, we had to introduce new features to Visual Flow to meet the client’s business needs, such as single sign-on functionality and DB2 native connection. Finally, it was implemented successfully, which allowed the team to fully migrate the existing ETL process to Visal Flow.
US-based growing startup serving healthcare industry has been successfully leveraging Visual Flow since January 2022.
The Visual Flow team helped in supporting clinical and medical research to empower the client’s healthcare capabilities and to provide cutting-edge services to patients all around the world.
Our client created a new frontend for easy mapping based on Visual Flow. Now its GUI allows the client’s business users – even those without strong technical background and good understanding of programming languages – to aggregate data from multiple sources, integrate it, and prepare it for further analysis.
Visual Flow backend is deployed on OpenShift cluster and customized. The Visual Flow backend engine is used as an optimized OpenShift image for Apache Spark Scala jobs and integrated to the analytics platform.
Reduce the preparation time and improve the quality of management reporting.
Implement a bank performance management system: corporate data warehouse and BI reports, planning and budgeting solutions.
Create a corporate data warehouse based on the industry-standard Banking Data Warehouse model and centralize information for reporting and budgeting.
Migrate the enterprise data warehouse from oracle to open source.
Create and maintain the corporate data warehouse.
Optimize the global maritime and inland transportation network and achieve operational efficiency, cargo capacity, and container availability.
Improve marketing analysis of production and registration of trucks.
Develop a flexible framework for analytical data mapping and interactive visualization.
Create interactive dashboards for a corporate training center.