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

      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

      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