DataSelf ETL+ Server
DataSelf ETL+ Server is a server-side software suite engineered to provide metadata along with optional services for DataSelf ETL+ deployments.
DataSelf ETL+ installations are responsible for the extraction, transformation, and loading of data into a data warehouse. The DataSelf ETL+ Server stores metadata which provide ETL+ installations with connection instructions to the source databases and the target data warehouse, the list of tables and columns to extract, and extract SQL Statements.
DataSelf ETL+ Server Components
Core Features - required: A MS SQL Server database hosting the ETL+ Metadata.
Server-side features for running Tableau Extract refreshes and Cloud Scripts - optional:
A Windows Server VM running a Microsoft SQL Server instance hosting the ETL+ Metadata and running Stored Procedures with access to the VM’s HD, plus a DataSelf ETL+ Agent running scheduled and on-demand tasks.
DataSelf ETL+ Web - Beta version - optional: A Linux Server environment hosting DataSelf ETL+ Web server. This server must have read and write rights to the ETL+ metadata database.
DataSelf ETL+ AWS Cloud Services
By default, ETL+ installations securely connect to the following DataSelf AWS Cloud Services:
DataSelf ETL+ Server operating 24x7 in AWS Oregon or Ohio regions.
VMs running Windows Server v2019.
MS SQL Server v2019.
IP-to-IP and SSL protected.
Backup every 12 hours.
Optional: you might host your own DataSelf ETL+ Server environment. Contact us to discuss it.
ETL+ AWS Cloud Services Maintenance
Windows Servers and MS SQL Servers are updated on the third Saturday of every month at 7pm PST. The usual downtime is a few minutes.
DataSelf ETL+ Agent is upgraded as new releases become available.
The DataSelf team monitors the Windows Servers, MS SQL Servers, DataSelf ETL+ Server, and ETL+ logs and acts on addressing infrastructure issues if/when they happen.
DataSelf communicates with its client base in case of unscheduled maintenance usually with a one-week advance notice.
Dedicated DataSelf ETL+ Server
Clients choose to use their dedicated ETL+ Server for one or more of the following reasons:
Best ETL+ metadata performance: Their ETL+ Server will have full resources and optimizations to address the client’s specific data analysis needs.
To abide by strict security and compliance requirements: The complete DataSelf solution can be moved into the client’s secured environment giving them total control. This architecture allows compliance with regulations such as HIPAA, GCC High, CMMC, ITAR, and SEC.
Click here to view its system requirements.
Contact your DataSelf representative to discuss your ETL+ Server needs.