Wistium

Wistium is SQEEL’s enterprise-grade platform designed to accelerate the development of corporate and industry-specific data platforms based on Data Mesh principles.
The platform enables organizations to build and evolve data products on a unified technology core, using a low-code approach, ready-made templates, and built-in capabilities for managing the full data lifecycle — from source integration to analytical data marts, BI dashboards, and ML use cases.
Wistium includes:
• built-in connectors for files, APIs, databases, Data Lakes, and S3-compatible storage
• data profiling tools, data crawlers, and built-in data quality checks
• design tools for ER models, dimensional models, and Data Vault 2.0
• low-code ETL/ELT and workflow orchestration with ready-made loading templates
• a Dry Run mode for safely testing data flows without writing results to databases or the Data Lake
• user, role, and change approval management based on the RBAC model
• built-in CI/CD and GitLab integration;
• centralized monitoring and operations control;
• the Koni AI assistant to support platform design and day-to-day work
• integration with Yandex Cloud services.
A key advantage of Wistium is its set of ready-to-use industry presets and templates, which make it possible to rapidly build specialized data platforms for pharmaceuticals, FMCG, banking, telecom, and other industries. For the pharmaceutical sector, Wistium provides prebuilt integration templates for CRM, MDLP / Chestny Znak, GISMT, pharmacy chains, distributors, IQVIA, AlphaRM, and e-commerce channels, enabling faster delivery of analytics, BI dashboards, data quality controls, and ML scenarios.
The platform is SQEEL’s intellectual property and is continuously developed as an industrial-grade software product.

Wistium includes a built-in installation wizard available at: http://{wistium-private-host}:8081/setup.

To implement the data loading processes, it is necessary to configure integration with the following services:

1. Integration with Yandex Managed GitLab
   • The GitLab repository URL will be required
   • An access token for a GitLab account with Maintainer rights to this repository will also be required

2. Integration with Yandex Managed Airflow
   • A CI/CD pipeline must be configured in the GitLab repository to deliver artifacts to Airflow
   • If Managed Airflow is used, a repository containing DAG files may be sufficient

3. Access to Object Storage
   • A service account must be attached to the Wistium virtual machine with the following configuration:
   o a service account with the storage.viewer role for the required buckets
   o a Lockbox secret named airflow-s3-keys containing static access keys for this service account in text or JSON format
   o a service account attached to the VM with the lockbox.payloadViewer role for the specified secret

It is recommended to perform the deployment and initial configuration of the product together with the SQEEL team. This helps ensure that the solution is set up in line with the customer’s target architecture, security requirements, and the required industry templates and usage scenarios.

• automated loading of data from the raw layer of the Data Lake, including files provided by distributors, pharmacy chains, and other external data providers in various formats such as xlsx, xlsb, and others
• connection to, loading, and processing of data from CRPT (GIS MT)
• loading, transformation, and subsequent integration of MDLP data into the corporate data platform

The publisher provides technical support for Wistium users in Yandex Cloud. You can contact the technical support team by email at wi.support@sqeel.ru. Support is available on business days from 10:00 to 19:00 (MSK).