ETL+ System Diagrams: v25.09 Beta
The following describes new features to be released through 2025.
DataSelf ETL+ 25.09
ETL+ Overview
ETL+ is a high-performance, no-code/low-code/full-code solution for data extraction, transformation, and loading. It seamlessly brings data from multiple sources into Microsoft SQL Server data warehouses, where it can be optimized, secured, and made ready for reporting.
Flexibility and Power
With ETL+, you can fully leverage SQL Server’s capabilities alongside your preferred reporting tools (such as Domo, Excel, Looker, MS Fabric, Power BI, Tableau). ETL+ is an additional layer of power and ease — not a limitation — giving you greater control over your analytics environment.
Automation and Scheduling
The ETL+ Agent can automatically trigger reporting tasks on a set schedule. Depending on security configurations, it can also trigger tasks on demand, including remote execution.
Standardized Data Modeling
DataSelf’s DFT data model converts source-specific databases into a highly scalable and customizable date modeling. This results in efficient, secure, and low-maintenance consolidated reporting and dashboards, while accelerating performance.
Modern Web UI
In addition to the Desktop UI, the new web interface allows users to securely manage ETL processes anytime, anywhere — streamlining administration and reducing dependency on IT.
AI-Assisted Data Modeling
The new ETL+ AI feature simplifies and accelerates data modeling, reducing complexity while enhancing accuracy.
Extensive No-Code Data Sources
Connect to more than 430 no-code data sources out of the box. View the full list here.
Self-Service Deployment
Deploy and manage ETL+ quickly and independently, empowering your team with faster time-to-value.
Value Proposition Diagram
Main ETL Web Page
Log Web Page
DataSelf ETL+ Data Flow
DataSelf ETL+ is comprised of the following parts:
ETL+ Server, which contains and manages ETL metadata. No transaction data reaches the ETL+ Server, just metadata and logs. The ETL+ Server is usually hosted in DataSelf Cloud, but it can also be hosted behind the client’s firewall. It has the following components:
Metadata Servers supporting ETL+ Desktop installations:
ETL+ Desktop metadata servers: MS SQL databases and stored procedures.
DFT - Dimension, Fact, and Time modeling: customizable templates for ETL+, MS SQL, Excel, Power BI, and Tableau. They enable plug-and-play reports and dashboards for popular ERPs, CRMs, and other systems.
ETL+ Web:
OS: Linux, Web App Server: Nginx.
Back-end Language: PHP; Framework: Laravel.
Front-end Language: Typescript/Javascript; Framework: Vue 3.
ETL+ Web metadata database: MS SQL Server.
Web API: Provides ETL+ API cloud services for ETL+ installations, users, and services. Languages: Typescript/Javascript, C#; Framework: ExpressJS.
AI: An AI Training Database and AI API integration (Linux, JavaScript, Chroma DB).
ETL+ Desktop that provides the user interface and executes ETL processes (Windows, C#, .NET). Depending on source systems, ETL+ might process the extraction and some transformation during the data loading into the data warehouse (ex.: extract and transform OData data into the target MS SQL), or all tasks might be executed directly by the target SQL Server under the ETL+ directions (ex.: extract and transform MS SQL source data into the target MS SQL).
Integration with 3rd party BI platforms such as MS Excel, MS Fabric, MS Power BI, and Tableau. For instance, ETL+ can trigger the refresh of Power BI semantic models and Tableau Cloud data sources as part of the ETL process.
The following diagram contains production components and new features to be released through 2025 (click the image to zoom in).
Architecture Options
Clients can deploy the DataSelf components for their specific needs. Here are the main architecture options:
DataSelf components hosted in DataSelf Cloud (AWS and/or Azure) - popular option.
The data warehouse is hosted in the client’s private cloud or on-premises. Usually, DataSelf ETL+ Desktop will also run on-premises / private cloud.
Have the ETL+ Metadata Server and data warehouse in the client’s private cloud or on-premises.
No need for API and Web Server if the Web UI features are not required.
Or the client can leverage the DataSelf Cloud Web platform by opening an IP-IP tunnel with DataSelf Cloud and the client’s ETL+ Metadata Server. No transaction data reaches the DataSelf Cloud.
Have all DataSelf components in the client’s private cloud or on-premises.
Once ETL+ Desktop loads the source’s metadata to its ETL+ Server, users can manage many ETL processes without connecting to the source system again. For instance, adding source tables and columns.
Using a fast and friendly no-code approach, the ETL+ ecosystem allows users to extract data from over 430 sources. Other sources such as API integration require low-code or full-code implementations.
The ETL+ system can also execute ETL tasks on schedule and demand.
DataSelf Analytics
DataSelf Analytics is a business intelligence (BI) and analytics solution designed to extend the reporting capabilities of ERP and CRM systems like Acumatica, Sage, Microsoft Dynamics, NetSuite, and others. It provides data visualization, reporting, and AI-driven insights to help businesses make better decisions.
Key Features of DataSelf Analytics
Streamlined Data warehousing powered by ETL+: Consolidates and optimizes data from multiple sources.
Pre-built BI Templates: Comes with 8,000+ customizable reports, dashboards, and KPIs.
Powerful data visualization: Uses Tableau and Power BI for advanced reporting.
Self-service BI: Enables non-technical users to create reports and dashboards easily.
AI & predictive analytics: Helps forecast trends and identify business insights.
Fast Deployment: Complete deployments can be done in hours.
Related Pages
Search terms:
data warehousing MS SQL Server based, MSSS, reporting and analytics tools, Tableau, Excel, Power BI, Crystal reports, SSRS, database management system, data sources, ETL, extract, data warehouse