Home


DATA INTEGRATION SIMPLIFIED.
EDIS is an Extract-Transform-Load (ETL) application for Microsoft SQL Server.
DEVELOP AND MAINTAIN ETL
FASTER THAN EVER BEFORE
No 3rd Party Language ■ No Packages ■ Just SQL
Business initiatives are transformed to work product at a much faster rate
  • Executives can expect a shorter development window
  • Iteration on existing processes become more fluid
  • Sourcing data is no longer an obstacle
Data integration is generated using only SQL commands; no 3rd party language required MORE
  • Beginners can function as professional ETL developers
  • Veteran developers can expedite and scale processes
  • Analysts can spend more time understanding the data and less time sourcing it
    Maintenance of ETL processes is more secure and transparent MORE
    • Database administrators (DBAs) have tighter security through the use of encrypted credentials
    • Auditors have a central repository that captures all ETL transactions

      DEVELOPER FEATURES


      With just a few lines of SQL code you can effortlessly import/export data and complete other ETL operations

      IMPORT/EXPORT DATA 

      • Import text files, csv's effortlessly

      • Supports delimited, fixed width, and ragged-right files

      • Autogenerate flat file exports on the fly

      • Connect to databases via OLEDB, ODBC, and ADO.NET

      EXCEL

      • Import & Export xls, xlsx, and xlsm files quick

      • Autogenerate Excel files on the fly

      • Format exported files with Autofilters, bold headers, and autofit columns

      • Add, rename, and clear worksheets with simple commands

      FTP OPERATIONS

      • Run SFTP, FTP, and FTP/SSL with simple parameters

      • Upload, download, and delete multiple files in a single batch

      • Get directory listing

      • Change ports, use passive connection

      • Use wildcards or file list

      SHAREPOINT 

      • Read/Write/Purge Lists with simple quick commands

      • Upload and download files from document libraries

      • Get library directory content

      • Connects to on-prem and Office 365 servers with ease

      GOOGLE BIGQUERY

      • Create Google Service Account Connections quick

      • Import data effortlessly

      • Autogenerate tables on the fly

      • Handles large results in batch

      ADDITIONAL FEATURES

      • Zip and unzip files quickly

      • SQL Commands

      • Execute Processes

      • Powershell

      • Local File Operations

      DBA TOOLS & FEATURES

      EDIS demystifies the ambiguity of ETL by providing centralized security and audit

      SECURITY

      • EDIS centralizes server connection management to a single table that is encrypted, which removes the hassle of managing configuration files in multiple environments

      • EDIS operates ETL actions using aliases for data sources, which means you do not need to provide credentials to developers anymore

      • Add and update connections with just a few lines of T-SQL and a few parameters

      • All parameters sent to EDIS are encrypted

      AUDIT

      • All ETL operations performed with EDIS are logged in an audit table

      • The audit table answers the who, what, when, and where

      • Start and end times, query ran, sources access, rows transferred, IP addresses, and user ID’s get logged along with many other items

      DEVELOPER SUPPORT

      • EDIS lives on the host SQL Server, which means developers only need SQL Server Management Studio (SSMS) installed on their workstation

      • No need to manage the setup of visual studio, SSDT, or BIDS

      • Developers can use SSMS and connect via client, which means they don’t have to be on the Windows server to develop and use EDIS

      • Using the audit table, identify overlap where multiple ETL processes access the same table

      SERVER UPGRADES

      • EDIS runs on one master package, which means the headaches associated with upgrading hundreds of SSIS Packages during a SQL Server upgrade are gone

      • When EDIS runs an ETL process, it creates a SSIS Package on the fly, executes, and then drops it, which means you don’t have to manage anymore SSIS packages

      SERVER CONSOLIDATION

      • EDIS enables the ability to consolidate multiple ETL SQL Servers due to its ability to scale, which saves you money on licensing costs, and alleviates the headaches with managing multiple ETL instances

      • EDIS has been running for over 3 years and gone through rigorous testing to handle high server concurrency

      INDUSTRY TESTED

      • EDIS is used internationally and ran on production servers

      • EDIS can scale to run hundreds of ETL tasks per hour

      • Works on multiple Windows environments including dekstop, professional, and server

      USER STORIES

      EDIS has made data integration an extremely simple process. The fact that it blows through the paradigm of creating packages and instead puts control right at your fingertips with simple T-SQL procedures is what should have been done years ago. It cuts out all the unnecessary steps and overhead of deploying packages and managing config files.
      Senior ETL Developer

      The speed at which we can develop new ETL is remarkable, just a few lines of code! Plus, the headaches associated with SSIS and managing packages is now gone. My team has been using EDIS everyday and has not opened SSIS for over 2 years
      Manager at Fortune 50 Company

      I never thought in years that data integration could be this fast and easy. The speed at which we can develop our ETL is now quick and efforless. Moreover, the ability to create Excel spreadsheets on the fly is a real game changer for us!
      Senior ETL Developer

      The learning curve with EDIS is so small compared to other software products out there. We are training new developers in just hours and we don't have to send them to expensive classes anymore. This product has truly redefined the concept of data integration in SQL Server. I would never go back to SSIS or anything else.
      Senior Software Engineer

      Central ETL audit, Excel Import/Export, SharePoint connectivity, control ETL workflow in T-SQL. This seems like a dream come true. SQLETL as the company name says is allowing you to develop, manage, code, and schedule your workflow with just T-SQL. So long Visual Studio, BIDS, SSDT, and SSIS packages. Hello EDIS.
      IT Manager

      We always have issues with setting up developer desktops with Visual Studio and SSDT. EDIS has removed that roadblock since all it needs is SSMS, and has given us time back to focus on managing the server, not managing the developer
      DBA Architect