Easy to use, fast and powerful ETL tools, Our prices start from only 100 USD per licence.

Work with: Text, XML, Excel, Access, DBF, Foxpro, Paradox, ODBC, BDE, OLE DB, MS Sql Server, Oracle, MySql, PostgreSQL, Firebird, Interbase, SQLite, POP3, SMTP, File System, FTP, SSL, Unicode, RSS, Windows Event Log, Google Spreadsheets, SalesForce, BrightPearl and QlikView.

Built-in scheduler, business rules designer, package designer, report designer, data browser. Powerful data transformation language, regular expressions and more...

You are here: Home

Differentia Consulting becomes a partner of ETL-Tools.com

Differentia Consulting are Elite QlikTech partners offering development, installation, training and support for QlikView Business Intelligence software.

Differentia Consulting becomes a partner of ETL-Tools.com

 Differentia Consulting has provided consulting, solutions, resourcing, support and training services to many different clients since 2002. We are long standing partners of IBM and Oracle, and a QlikView Elite Solution Provider with QlikView customers from all sectors and core technologies (Oracle, SAP, Infor, IFS, Microsoft, SAGE, Siebel, SalesForce, SugarCRM etc). Differentia Consulting has an ERP heritage; however,  the company has expanded into the agile analytics space both from a software resale and value add consulting perspective

Differentia Consulting has an excellent reputation for enabling organisations to improve their performance primarily through the analysis of existing business problems and the development of plans for improvement utilising disruptive and Lean IT tools such as QlikView.

Creating QVX files

Latest version of Advanced ETL Processor can create 14000 QVX records per second, approximately 1 million records per minute.

This is 10 x increase comparing to the previous version!

Creating QVX

There are two ways of creating QVX files using packages or from the transformation. It is possible to save all tables in the database into QVX files with several clicks. And it is also possible to perform complex data transformations.

Using dynamic SQL for ETL transformations

Based on users feedback in latest version of Advanced ETL Processor and Visual Importer ETL we have made it possible to edit Insert/Update/Delete/Count SQL statements manually.

To enable this option

  • Click Data target/Writer properties
  • Select Transformation tab
  • Tick "Use user defined SQL" check box 
  • Edit every SQL statement individually.

Note

  • To regenerate the SQL statements clear it and open it again.
  • Keep the fields order same and in there are any changes with target table structure, regenerate everything again

Dymamic SQL


New Year with New Business intelligence software

Today we are proud to announce that after several months of hard work and intensive testing new versions of Visual Importer ETL, Advanced ETL Processor, Active Table Editor and Database Browser  are finally live. They bring to the users enormous number of useful changes, usage improvements and bug fixes.

AETL - Package Designer

  • Parallel Processing
  • Highly optimised code
  • Execution agent is now only 5 mb (compare this to some java etl tools)
  • Schedule for execution Packages, Transformations and SQL scripts
  • Application Notes
  • Notes for Directories and Connections.
  • Connection testing for FTP,SMTP and POP3
  • Mutiple SMTP, POP3, and FTP connections
  • CRC16,CRC24,CRC32,Adler32,CRC64,eDonkey,eMule,MD4,
    MD5,RIPEMD160,SHA1,SHA224,SHA256,SHA384,SHA512,
    Whirlpool checksums
  • Package Debugging
  • Multiple SQL editors
  • New repository structure compatible with Database browser,
    Advanced ETL Processor and Active Table Editor
  • Design and Generate Reports
  • Easy agent management
  • Run Packages, Transformations, Import scripts and SQL scripts
    from the command line
  • 300 data transformation and validation functions
  • Edit lookup data
  • Simplified Repository management
  • Execution log has Execution time percentage
  • Schedule package execution directly from the package designer
  • Same for sql scripts and data transformations
  • Schedule for execution on specific computer
  • Schedule for execution using agent only as option
  • Easy agent management
  • Simplified Repository management
  • Agent status logging and current agent tasks grid
  • Documentation update
  • Support for themes
  • After and Before transformation functions

Have an Idea? Let us know and we will implement it for you.
Do not know how to transfom the data, let us know and we will help you.

Visual Importer ETL - Report Designer

Please use our support forum to provide us with feedback, we are are always happy to assist anyone having problems

More Articles...

Page 4 of 11

Go to top