Active Table Editor

  • 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 allows editing lookup 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 is how Active Table Editor was born.

    All our ETL tools have no limitations, which 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

  • New Release Of Active Table Editor

    The most important change is how settings are stored.  All of them used to be saved in the registry key HKEY_LOCAL_MACHINE and since Microsoft had tightened windows security it brought a lot of problems and error messages.  In order to make life everyone easier, the decision was made to move common settings into "ini files" and user-specific settings to HKEY_CURRENT_USER  registry key. The benefit of storing common settings in ini files that it is extremely easy to copy repository settings from one computer to another.  

    Active Table Editor   5.3.4.0

    Other changes are:
    • Added: Support for MongoDB
    • Fixed: User access issues
    • Fixed: Issues with checking the version
    • Fixed: Backup/Restore Issues
    • Improved: Third-party components update
    • Improved: Various bug fixes and improvements

     

    More information:

    All settings are stored in C:\ProgramData\ETL-Tools.com folder, that makes moving software to a different computer much easier.

    ATEOptions.iniholds designer user interface settings plus global variables values

    Connections.ini holds a list of all available repository connections

    Note: This list is shared among all applications

    ATEConnection.ini this file holds repository connection name

    Note: It might necessary to amend repository connection details after installation

    Repository Upgrade Procedure
  • A new release of Active Table Editor is available for download.

    Changes are small but useful especially if you have a lot of forms or reports to manage

    Both Group Properties and Add Document Dialogue support incremental search now

    Active Table Editor Group Dialog Properties

    Visit Support Forum Download Buy It
  • A new version of Active Table Editor is available for download

    Changes are:

    Added option to delete all records

    ATE Delete All Records

     

    Visit Support Forum Download Buy It
  • Great news Active Table Editorsupports now incremental search

    ATE

    Other changes are:

    + Third-party components update
    + Incremental search was added to all grids
    + Export to RTF was introduced
    + Excel export formats improvements
    + Various Interface improvements
    + Documentation update
    - Minor bugs fixes
    - Spelling corrections

    Visit Support Forum Download Buy It
  • Good Software can be always made better. In the latest release of Active Table Editor and Database Browser, we have added support for MRU Lists

    MRU List is a list of the most recently used values. MRUList is displayed when the user types text in the grid editor

     mru list

  • The new version of Active Table Editor available for download.

    Based on the customer feedback we have added a new option "Large Icons"

    That makes it easier to use Active Table Editor on tablets

    We would like to thank Julian Wallasch for the assistance

    Options Dialogue

    Large Icons

    Watch Online Tutorials Download
  • Several of our customers have asked us recently how to run Advanced ETL Processor or Visual Importer ETL Package from Active Table Editor or any other application.

    All of these customers use the agent for execution.

    The agent reads the QUEUE table several times per minute if there is something to execute it runs it.

    QUEUE table has a lot of fields and it is not very clear which values to use.

    Here is basis SQL Server stored procedure:

    CREATE PROCEDURE [dbo].[EXECUTE_OBJECT]
    (
    @LogDirectory NVARCHAR(255) ='',
    @ComputerToExecuteOn NVARCHAR(255) ='',
    @ObjectID Int,

    @UseAgent Int = 1, -- 1 = True, 0 = False
    @ExecuteOnComputer Int = 1
    )
    AS BEGIN BEGIN TRAN
    -- Calculating ID
    DECLARE @ID Int
    select @ID =max(ID)+1 from ID_GENERATOR where id_type=2
    update ID_GENERATOR set ID=@ID where id_type=2
    INSERT INTO QUEUE
    (QUEUE_ID,
    OBJECT_ID,
    OBJECT_TYPE,
    OBJECT_NAME,
    LOG_FILE,
    SUBMITED,
    STATUS,
    USE_AGENT,
    EXECUTE_ON_COMPUTER,
    COMPUTER_TO_EXECUTE_ON,
    COMPUTER_NAME,
    OSUSER )
    SELECT @ID as QUEUE_ID,
    OBJECT_ID, OBJECT_TYPE,
    NAME as OBJECT_NAME,
    @LogDirectory+'\Package_'+Cast(@ID as VARCHAR)+'.log' as LOG_FILE,
    getdate() as SUBMITED, 'P' as STATUS,
    @UseAgent as USE_AGENT,
    @ExecuteOnComputer as EXECUTE_ON_COMPUTER,
    @ComputerToExecuteOn as COMPUTER_TO_EXECUTE_ON,
    @@SERVERNAME as COMPUTER_NAME,
    user as OSUSER
    from objects_tree
    where object_id=@ObjectID
    COMMIT
    END
    GO

    Execution example:

    EXEC [EXECUTE_OBJECT] 'C:\TEMP','DBSLCOMPUTER',126,1,0

    Parameters:

    Log Directory:

    Log Directory

    Object ID:

    The rest of the parameters is self-explanatory

    Active Table Editor Execute Button

  • Watch this video to get started with Active Table Editor. More videos are below. 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  

  • New version ofof Active Table Editor is available for download

    Changes are:

    + Added: Vertical Grid Menu item type
    + Third-party components update
    + Improved : Incremental Search Functionality

    VerticalGrid

    More Information

 

This site uses cookies. By continuing to browse the site, you are agreeing to our use of cookies