Home http://www.dbsoftlab.com/ Sun, 05 Feb 2012 00:51:15 +0000 Joomla! 1.5 - Open Source Content Management en-gb Working with QVX files http://www.dbsoftlab.com/working-with-qvx-files.html http://www.dbsoftlab.com/working-with-qvx-files.html Those people who work with QlikView know that it requires direct connection to the database to pull the data from, which is not possible to implement in some situations. One of the solutions is to use QVD files but again there is no way to create them without using QlikView.

In version 10 QlikView has introduced support for QVX files.

QVX (QlikView data eXchange) is a new file/stream format for high performance data input into QlikView. A QVX formatted file contains metadata describing a table of data and the actual data. In contrast to the QVD format, which is proprietary and optimized for minimum transformations inside QlikView, the QVX format is public and requires a few transformations when exporting data from traditional data base formats.

Adavanced ETL processor and Visual Importer ETL allow the user to export entire data warehouse into QVX files just with in few click and no programming


Create QVX form any datasource

Data can be generated from virtually any data source.

Note

All data is exported as UTF8 text using row delimiter

Here is the link to file format specification.

http://community.qlikview.com/servlet/JiveServlet/previewBody/2677-102-1-2852/QlikView%20QVX%20File%20Format.pdf

Online tutorial.

How to save entire datawarehouse into QVX files with just s few cliks

]]> info@dbsoftlab.com (Administrator) frontpage Tue, 02 Dec 2008 17:26:25 +0000 New Year with New Business intelligence software http://www.dbsoftlab.com/new-year-with-new-business-intelligence-software.html http://www.dbsoftlab.com/new-year-with-new-business-intelligence-software.html 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

]]> info@dbsoftlab.com (Administrator) frontpage Tue, 02 Dec 2008 17:26:25 +0000 Visual Importer ETL version 8 is ready for testing http://www.dbsoftlab.com/visual-importer-etl-version-8-is-ready-for-testing.html http://www.dbsoftlab.com/visual-importer-etl-version-8-is-ready-for-testing.html After several months of hard work  Visual Importer ETL version 8 is finally available for download. It introduces enormous amount of useful changes, improvements and bug fixes:

Dowload Professional or Enterprise version
  • Package Debugging
  • Parallel execution
  • Highly optimised code
  • Application Notes
  • Various bugs fixes and improvements

Upgrading Reposistory

Support will provide assistance to existing customers who pay for support and maintenance.

Reporting problems

Please use our support forum to provide us with feedback. we are currently looking for beta testers and will be happy to assist anyone having problems

New version of Visual Importer ETL

]]> info@dbsoftlab.com (Administrator) frontpage Tue, 02 Dec 2008 17:26:25 +0000 Annoncing Active Table Editor - Version 5 http://www.dbsoftlab.com/annoncing-active-table-editor-version-5.html http://www.dbsoftlab.com/annoncing-active-table-editor-version-5.html After months of hard work  Active Table Editor version 5 is available for download. It introduces enormous amount of useful changes, improvements and bug fixes:
  • Linked Reports
  • Ability to print individual records
  • Various bugs fixes and improvements

Upgrading Reposistory

Support will provide assistance to existing customers who pay for support and maintenance.

Reporting problems

Please use our support forum to provide us with feedback. we are currently looking for beta testers and will be happy to assist anyone having problems

New version of Active Table Editor

]]> info@dbsoftlab.com (Administrator) frontpage Tue, 02 Dec 2008 17:26:25 +0000 AETL beta 5 status update http://www.dbsoftlab.com/aetl-beta-5-is-status-update.html http://www.dbsoftlab.com/aetl-beta-5-is-status-update.html
  • Documentation is ready
  • Professional version is ready or testing

    • Download Professional version

    ]]>     info@dbsoftlab.com (Administrator) frontpage Sun, 04 Dec 2011 20:53:14 +0000     Beta Version 5 of Advanced ETL Processor - is available for testing http://www.dbsoftlab.com/overview.html http://www.dbsoftlab.com/overview.html Advanced ETL Processor Enterprise version 5 is available for download. It introduces enormous amount of useful changes, improvements and bug fixes:
    • New repository structure compatible with Database browser and future
      releases of Visual Importer ETL and Active table editor
    • Parallel data 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
    • Run Packages, Transformations and SQL scripts from command line
    • Application Notes
    • Notes for Directories and Connections.
    • Connection testing for FTP,SMTP and POP3
    • 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
    • Look-up object
    • Various bugs fixes and improvements

    Why it was necessary to create new version?

    If you worked with Advanced ETL Processor and Visual Importer ETL you have probably already noticed that they share common functionality. What we are trying to is to merge code of four our products together and remove all code duplication. This will make easier to make future releases  and it will reduce possibility of introducing bugs.

    Why repository  structure is different now

    Old repository structure did not have enough room for functionality expansion. it was very difficult to and new connection types or to modify exiting objects properties. New repository is designed in such a way that it will not be necessary to change it in most of the cases.

    Upgrading Reposistory

    Support will provide assistance to existing customers who pay for support and maintenance.

    Documentation

    Documentation is being updated at the moment.

    Reporting problems

    Please use our support form to provide us with feedback. we are currently looking for beta testers and will be happy to assist anyone having problems

    New beta version of Advanced ETL Processor

    Download
    ]]>     info@dbsoftlab.com (Administrator) frontpage Tue, 02 Dec 2008 17:26:25 +0000     Something big is coming to the data transformation http://www.dbsoftlab.com/something-big-is-coming-to-the-data-transformation.html http://www.dbsoftlab.com/something-big-is-coming-to-the-data-transformation.html Very soon brand new version of Advanced ETL Processor will available for download.

    This would be completely new release with a lot changes

    Such as

    + Parallel processing
    + Execution agent management
    + Abilty to schedule SQL scripts and Transformations
    + Enhanced repository structure
    + Ability to share same repository between Database browser, Active Table Editor and Visual Importer
    + Lots of small enhancements and improvements

     

    Big Data transformation

     

    Please contact us if you are willing to help with testing.

    ]]>     info@dbsoftlab.com (Administrator) frontpage Sun, 18 Sep 2011 17:33:13 +0000     Database browser version 4.0 http://www.dbsoftlab.com/data-base-browser-supports-tabs.html http://www.dbsoftlab.com/data-base-browser-supports-tabs.html New version of Database browser is available for download

    In this release we have introduced support for tabs

    Support for tabs

    Full list of chages

    + Support for multiple tabs
    + Connections and Execution history are stored in separate database now
    + New connection dialog
    + Comments for connections
    + Create date,update date and user name information for connections

    ]]>     info@dbsoftlab.com (Administrator) frontpage Sun, 18 Sep 2011 17:33:13 +0000     Debugging data transformations http://www.dbsoftlab.com/debugging-data-transformations.html http://www.dbsoftlab.com/debugging-data-transformations.html New version of Advanced ETL Processor is available for download

    In this release we have introduced debugger and greatly enhanced development of Data transformation packages

    New SQL execution log

    Full list of chages

    + Package debugger was introduced
    + Breakpoints were introduced
    + Execute single package object option was introduced
    + Project Tree View -  COLLAPS/EXPAND buttons were added
    + More generic log viewer
    + Ability to group packages, sql scrits reports and emails was addedd
    + Package objects have objects tree for the selection now
    + Execution agent writes startup error messages in the log file
    - Disaprearing tree nodes problem was addressed
    - "Progam" file was created on drive c
    - Double attachments
    - XML XSLT tranformation fix
    - Some auto format issues were addressed
    - Minor interface tweaks
    - Addressed issues related to running execution agent on win64

    Great work! That might be a World’s Record for publishing a new version of a major application.

    ]]>     info@dbsoftlab.com (Administrator) frontpage Sun, 18 Sep 2011 17:33:13 +0000     SQL Execution log http://www.dbsoftlab.com/sql-execution-log.html http://www.dbsoftlab.com/sql-execution-log.html New version of Database Browser is available for download

    In this release we have greatly enhanced SQL Execution log functionality.

    New SQL execution log

    ]]>     info@dbsoftlab.com (Administrator) frontpage Sun, 18 Sep 2011 17:33:13 +0000