ETL+ System Diagrams: v2025 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 two main 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.
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).
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.
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
DataSelf Analytics Processes
The following diagram contains production components and new features to be released through 2025.
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