ETL+ System Diagrams: v2025.05 Beta
DataSelf ETL+
An ETL+ powered data warehousing provides the following benefits:
ETL+ is a high-performance, no-code, low-code, full-code Extraction, Transform, and Load tool to get your data sources' data into MS SQL Server data warehouses and then optimize and secure access for reporting.
You can leverage regular MS SQL and reporting tools and features in conjunction with ETL+. ETL+ is an additional powerful and easy-to-use tool, not a limitation on what you can do.
The ETL+ Agent can trigger reporting tasks on schedule. Depending on user-selected security settings, one can use it to trigger tasks on demand remotely.
DataSelf ETL+ Data Flow - Data Warehousing
DataSelf ETL+ is comprised of the following parts:
ETL+ Server that contains and manages the 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 all ETL+ installations that have their metadata in our cloud:
ETL+ metadata servers.
DFT: Dimension, Fact, and Time modeling templates.
ETL+ Web:
ETL+ Web UI.
ETL+ Web Server for Web UI metadata.
API: Provides ETL+ API cloud services for ETL+ installations, users, and services.
AI: An AI Training Database and AI API integration.
ETL+ Desktop that provides the user interface and executes ETL processes. 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.
Architecture options:
All DataSelf components are hosted in our cloud.
Have the data warehouse hosted in the client’s private cloud or on-premises.
Have the ETL+ metadata Server and data warehouse in the client’s private cloud or on-premises; and ETL+ Web, API, and AI in DataSelf’s 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.
The following diagram contains production components and new features to be released through 2025 (click the image to zoom in).
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.
Learn more about DataSelf Analytics here: https://dataself.atlassian.net/wiki/spaces/DS/pages/edit-v2/2001666087#DataSelf-Analytics-Processes
Related Pages
https://www.dataself.com/architecture/ – architecture diagram on dataself.com (main corporate website)
In this section
Search terms:
data warehousing MS SQL Server based, MSSS, reporting and analytics tools, Tableau, Excel, Power BI, Crystal reports, SSRS, data base management system, data sources, ETL, extract, data warehouse