Advanced ETL Processor Professional x86 x64

PC Software

  • Filter
  • Time
  • Show
Clear All
new posts

    Advanced ETL Processor Professional x86 x64

    Advanced ETL Processor Professional is a straightforward and reliable piece of software designed to automate all your business processes. It saves you time so you can concentrate on the main aspects important for your company.

    Advanced ETL Processor Professional x86 x64

    Connect to a repository of choice
    Using this ETL utility you are able to perform complex data validation and transformation actions, create Insert statements from any data source and simply load data from files into BLOB fields.

    The main window provides a number of settings for the three stages of reading, transformation and writing. This is facilitated by the main tool bar and a list of available objects.
    The left panel located in the Design tab enables you to connect to whatever repository you want, then handle any kind of database be it Oracle, Microsoft Access, SQL Server, MySQL, PostgreSQL or Excel spreadsheets. The program provides a mechanism by which a number of different systems and protocols can interact in order to help you process a number of tasks from start to finish. It can handle a number of different functions and services such as processing databases, e-mail protocols and Office documents.

    Integrate multiple data sources and execute SQL statements
    The Maintain tab enables you to organize all the available databases, analyze ODBC drivers and start the execution agent. Also, you are able to create a new repository by selecting the application type such as Visual Importer, then specify details such as name, file and user credentials.

    You can navigate to the ‘Execution Log’ tab if you want to analyze the activities of individual processes during their execution. It displays the file type and the description for each process.

    What’s more, by accessing the ‘Run SQL’ tab you can view all the available connections and execute your own SQL statements. This way, the utility lets you easily integrate data from multiple data sources or split data from one database to many files.

    To end with
    Being designed to automate everyday routine tasks, Advanced ETL Processor Professional is a reliable and effective solution when it comes to generating reports, saving attachments, sending e-mails and exporting data from any database.

    Features : 
    Multiple Delimited or Fixed width Text files
    Multiple Excel files + Multiple Excel Spreadsheets
    Multiple MS Access Databases
    Multiple DBF Files
    Any ODBC compliant database
    Full support for ODBC connection strings
    OLE DB Datasource
    MS SQL Server
    Multiple Tables
    POP3 + SSL
    File System
    190 Validation Functions
    String Validation
    Number Validation
    Date Validation
    Time Validation
    Validation Against list of values
    Regular Expressions: Post codes, Phone Numbers, VAT Numbers ETC
    15 Transformation Functions
    String Transformation
    Number Transformation
    Date Transformation
    Multiple Date Formats
    Translating coded values (e.g., if the source system stores 1 for male and 2 for female, but the warehouse stores M for male and F for female)
    Deriving a new calculated value (e.g., sale amount = qty * unit price)
    Joining together data from multiple fields
    Summarizing multiple rows of data (e.g., total sales for each store, and for each region)
    Generating surrogate key values
    Transposing or pivoting (turning multiple columns into multiple rows or vice versa)
    Splitting a column into multiple columns (e.g., putting a comma-separated list specified as a string in one column as individual values in different columns)
    Customised Transformation
    Multiple Data Targets
    Delimited or Fixed width Text files
    MS Access Databases
    Microsoft Excel Files
    DBF Files
    Oracle 7-11g database (using OCI API)
    Full support for Oracle Instant Client
    SQL server 7-2008 (using BCP API)
    Any ODBC compliant database (Using ODBC API)
    Ole DB
    Full support for ODBC connection strings
    Generate Sql Insert Script
    SMTP + SSL
    File System
    There are two ways of loading available:
    Oracle direct path loading
    Conventional path
    SQL server:
    This software uses the same API as Microsoft DTS service


    Similar Threads

    Advanced ETL Processor Professional x86/x64


      شكرا لك الغالي ابو محمد

      كل التحيات

        جزاك الله كل خير