Click here to learn about DataSelf ETL+ Deployment Options.
Architecture and 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.
-
-
-
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+:
-
AI Training Database that has our knowledge base plus clients' metadata (no private data).
-
AI API integration (Linux, JavaScript, Chroma DB).
-
DataSelf MCP (Model Context Protocol) Servers can connect your data warehouse, DFT+, Power BI, Tableau, KPI+ to your AI tools such as from Claude, OpenAI, and others.
-
-
-
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.
DataSelf ETL+ Overview
DataSelf Value Proposition
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.
AI-Assisted Data Modeling
The new ETL+ AI feature simplifies and accelerates data modeling, reducing complexity while enhancing accuracy. At your choice, leverage DataSelf MCP Servers to securely connect AI agents, automation platforms, Power BI, Tableau, and external applications to your governed data warehouse environment. MCP Servers enable standardized AI-ready access to business data, analytics models, dashboards, and operational workflows while maintaining centralized security and control.
Broad Connectivity
ETL+ supports over 430 prebuilt no-code connectors and easy AI-assisted extraction from 500K+ data sources for business applications, databases, cloud services, files, and APIs. Additional integrations can be implemented using low-code or full-code approaches when greater flexibility or custom logic is required.
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.
Self-Service Deployment
Deploy and manage ETL+ quickly and independently, empowering your team with faster time-to-value.
Main ETL Web Page
Log Web Page (& Live Log)
DataSelf Analytics Plus
DataSelf Analytics Plus is the next-generation business intelligence (BI) with AI solution designed to extend the reporting capabilities of your data silos such as ERP and CRM systems. It provides data visualization, reporting, and AI-driven insights to help businesses make better decisions. It includes extensive pre-mapped integrations and templates to systems such as ADP, Acumatica, HubSpot, Microsoft Dynamics, NetSuite, QuickBooks, Sage, Salesforce.com, SAP, Shopify, and other systems.
Key Features of DataSelf Analytics
-
Streamlined Data warehousing powered by ETL+: Consolidates and optimizes data from multiple sources.
-
DFT+: automated, source agnostic, and AI-assisted data modeling to build and maintain your single version of the truth.
-
KPI+ (Pre-built BI Templates): Comes with 8,000+ customizable reports, dashboards, and KPIs.
-
Powerful data visualization: Uses Tableau and Power BI for advanced reporting.
-
AI & predictive analytics: Helps forecast trends and identify business insights.
-
Self-service BI: Enables non-technical users to create reports and dashboards easily.
-
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