Tutorial

  • Introduction to Active Table Editor

    We have delivered a lot of data transformation and integration projects and one day we realized, that we need to put something on the end user computer, which will allow editing lookups tables, running reports and performing calculations. Our users did not want to run SQL plus or Microsoft SQL Server Management Studio. It is just too complex for them.

    This how Active Table Editor was born.

    All our ETL tools have no limitations, that means you can load your data today and solve all the data quality problems right now.

    Our WIKI has more detailed information if you are stuck post your question on our support forum and we will do our best to assist you

  • Editing QVD Files using Q-Eye

     

    If you are stuck post your question on our support forum and we will do our best to assist you

  • How to load data from a delimited file into MS Access

    In this tutorial, you will learn how to use Visual Importer to create a simple data transformation. The transformation that you create takes data from a comma delimited file and then inserts the data into an MS Access table.

    All our ETL tools have no limitations, that means you can load your data today and solve all the data quality problems right now.

    Our WIKI has more detailed information if you are stuck post your question on our support forum and we will do our best to assist you

    Visual importer ETL is the first software product we created. Advanced ETL processor is fully compatible with it and it has much more features. 
    Most of Advanced ETL Processor videous are relevant to Visual Importer ETL except the ones desribing how to work with transformations.
  • Introduction to Advanced ETL Processor

    Learn how to load data from an Excel file into the database data in 5 minutes.

    All our ETL tools have no limitations, that means you can load your data today and solve all the data quality problems right now.

    Our WIKI has more detailed information if you are stuck post your question on our support forum and we will do our best to assist you

  • How to edit data in Lookup Tables

    Active Table Editorcan edit data in any lookup table or database.

    In this tutorial we will be creating customer lookup, designing menu items and working with data grid.

    All our ETL tools have no limitations, that means you can load your data today and solve all the data quality problems right now.

    Our WIKI has more detailed information if you are stuck post your question on our support forum and we will do our best to assist you

  • Designing Data Input Forms

    This tutorial walks you through designing Designing Data Input Forms and explains how you can edit lookups and slowly changing dimensions in any database.

    This tutorial is intended for users familiar with fundamental database operations, but who have limited exposure to the new features available in Active Table Editor.

    All our ETL tools have no limitations, that means you can load your data today and solve all the data quality problems right now.

    Our WIKI has more detailed information if you are stuck post your question on our support forum and we will do our best to assist you

  • Getting familiar with Advanced ETL Processor Enterprise user interface

    All our ETL tools have no limitations, that means you can load your data today and solve all the data quality problems right now.

    Our WIKI has more detailed information, if you are stuck post your question on our support forum and we will do our best to assist you

  • QVD File field types

     

    If you are stuck post your question on our support forum and we will do our best to assist you

  • Working with Automap DIALOGUE

    In this tutorial, you will learn how to use Visual Importer Automap function.

    Quite often it is necessary to work with very wide files and it can be very time-consuming to perform data mapping. With auto-map function, it can be done in seconds

    All our ETL tools have no limitations, that means you can load your data today and solve all the data quality problems right now.

    Our WIKI has more detailed information if you are stuck post your question on our support forum and we will do our best to assist you

    Visual importer ETL is the first software product we created. Advanced ETL processor is fully compatible with it and it has much more features.
    Most of Advanced ETL Processor videous are relevant to Visual Importer ETL except the ones desribing how to work with transformations.
  • Extracting data from QVD files

    This tutorial demonstrates how data can be extracted from QlikView QVD files with Advanced ETL Processor

    It is intended for users familiar with fundamental ETL operations, but who have limited exposure to the new features available in  Advanced ETL Processor.

    All our ETL tools have no limitations, that means you can load your data today and solve all the data quality problems right now.

    Our WIKI has more detailed information, if you are stuck post your question on our support forum and we will do our best to assist you

  • How to Import and Export Data

    Importing data is the process of retrieving data from sources external to Active Table Editor (for example, an Excel file) and inserting it into database tables. Exporting data is the opposite process of extracting data from database tables into some user-specified format.

    Active Table Editor can export data into csv, html and Excel files and Import it back from Excel files.

    Import and export are designed to save user time or can be used to import starting set of data

    In this tutorial, we will be Exporting and Importing data. We will also review common imports problems.
    This tutorial is intended for users familiar with fundamental database operations, but who have limited exposure to the new features available in Active Table Editor.

    All our ETL tools have no limitations, that means you can load your data today and solve all the data quality problems right now.

    Our WIKI has more detailed information if you are stuck post your question on our support forum and we will do our best to assist you

  • Repository Database

    In this tutorial, you will learn how to work Advanced ETL Processor repository.

    The best way to become acquainted with the new tools, controls and features available in Advanced ETL Processor is to use them. This tutorial walks you through repository creation, maintenance, import and export processes.

    This tutorial is intended for users familiar with fundamental database operations, but who have limited exposure to the new features available in Advanced ETL Processor

    All our ETL tools have no limitations, that means you can load your data today and solve all the data quality problems right now.

    Our WIKI has more detailed information if you are stuck post your question on our support forum and we will do our best to assist you

  • Working with Date fields

    In this tutorial, you will learn how to use Visual Importer ETL to work with date fields.

    All our ETL tools have no limitations, that means you can load your data today and solve all the data quality problems right now.

    Our WIKI has more detailed information if you are stuck post your question on our support forum and we will do our best to assist you

    Visual importer ETL is the first software product we created. Advanced ETL processor is fully compatible with it and it has much more features.
    Most of Advanced ETL Processor videous are relevant to Visual Importer ETL except the ones desribing how to work with transformations.
  • Learn how to create QVD files

    This tutorial demonstrates how to create QlikView QVD files with Advanced ETL Processor

    All our ETL tools have no limitations, that means you can load your data today and solve all the data quality problems right now.

    Our WIKI has more detailed information, if you are stuck post your question on our support forum and we will do our best to assist you

  • CREATING REPOSITORY DATABASE

    The repository is a very important database. It holds all the metadata used by our products, therefore it is important to understand how to work with it.

    All our ETL tools have no limitations, that means you can load your data today and solve all the data quality problems right now.

    Our WIKI has more detailed information if you are stuck post your question on our support forum and we will do our best to assist you

  • How to Design Reports

    This tutorial describes how to use the Active Table Editor  Report generator.

    In particular, it covers using query builder for reports creation, report creation wizard and security settings required to view the reports

    All our ETL tools have no limitations, that means you can load your data today and solve all the data quality problems right now.

    Our WIKI has more detailed information if you are stuck post your question on our support forum and we will do our best to assist you

  • How to load data from an Pivot Table into a database

    This tutorial is intended for users familiar with fundamental database operations, but who have limited exposure to the new features available in Visual Importer.

    All our ETL tools have no limitations, that means you can load your data today and solve all the data quality problems right now.

    Our WIKI has more detailed information if you are stuck post your question on our support forum and we will do our best to assist you

    Visual importer ETL is the first software product we created. Advanced ETL processor is fully compatible with it and it has much more features.
    Most of Advanced ETL Processor videous are relevant to Visual Importer ETL except the ones desribing how to work with transformations.
  • How to Run Stored Procedures

    In this tutorial, we will be Running stored procedures.

    Quite often it is necessary to let the user change some parameters and run the stored procedure. For example, the user might want to run some calculations or prepare data for reporting in data-warehouse. This can be done with Active Table Editor in 10 minutes.

    Scripts used in this demo:

    CREATE TABLE [dbo].[calculation_parameters](
    [start_date] [datetime] NOT NULL,
    [end_date] [datetime] NULL
    ) ON [PRIMARY]

    GO

    CREATE PROCEDURE [dbo].[p_Calculate]
    (
    @start_date datetime,
    @end_date datetime
    )
    AS
    begin
    set nocount on
    end
    GO

    set nocount on
    declare @start_date datetime;
    declare @end_date datetime;

    select @start_date=max(start_date) from calculation_parameters;
    select @end_date=max(end_date) from calculation_parameters;

    exec p_Calculate @start_date, @end_date


    All our ETL tools have no limitations, that means you can load your data today and solve all the data quality problems right now.

    Our WIKI has more detailed information if you are stuck post your question on our support forum and we will do our best to assist you

  • Working With Repository Backups

    The repository is a very important database. It holds all the metadata used by our products, therefore it is important to understand how to work with it.

    All our ETL tools have no limitations, that means you can load your data today and solve all the data quality problems right now.

    Our WIKI has more detailed information if you are stuck post your question on our support forum and we will do our best to assist you

  • Performing repository synchronisation

    The repository is a very important database. It holds all the metadata used by our products, therefore it is important to understand how to work with it.

    All our ETL tools have no limitations, that means you can load your data today and solve all the data quality problems right now.

    Our WIKI has more detailed information if you are stuck post your question on our support forum and we will do our best to assist you

We have 1191 guests and no members online