Visual Importer Professional Trial

Written by Admin on. Posted in Software

Visual Importer Professional TrialVisual Importer Professional is a comprehensive and reliable piece of software that provides you with an integrated BI (Business Intelligence) solution for deploying and designing data warehouses. It helps you to export SQL statements, create and execute queries and schedule SQL scripts for execution on a regular basis. Compared to other products of its kind, Visual Importer Professional is able to receive and process e-mails and attachments, decompress archives, create or delete directories on FTP servers, as well as run calculations during import. Irrespective of the database you choose to work with, such as MySQL, PostgreSQL, SQLite, Oracle, MS SQL Server, Firebird orAccess, to name a few, you need to make sure that all the ODBC drivers are working properly into your computer, otherwise you won’t be able to import / export the necessary data. The main window of the application is intuitive and easy to work with, since it comes with seven tabs that will ease your work, namely ‘Maintain’, ‘Design’, ‘Monitor’, ‘Schedule’, ‘Version Control’, ‘Run SQL’ and ‘Make Notes’. The first tab helps you to manage all the ODBC drivers, connect to a specific repository, backup the entire database, register a new agent and modify the log directory. In case you want to create a new repository, a useful wizard stays at your disposal. By accessing the ‘Create New’ button, you will be guided through all the required steps. Because the repository stores all the important objects such as connections, export scripts and packages, it is very important to understand how it works, create backups and get back all your data in case you run into system failures. Since the program enables you to group objects together into categories, you can manage all of the available database connections along with their directories, repository backups and temporary files. By accessing the ‘Run SQL’ tab you are able to execute SQL queries, from simple to complex ones. The left panel allows you to choose the database you want to connect to, access the table you want to work with and preview all its data in the main window. The right-click menu allows you to make use of TRUNCATE, DELETE or COUNT(*) functions. To wrap it up, Visual Importer Professional comes packed with useful features and options that combine components of both ETL (Extraction, Transformation and Loading) and design tools into one application.
Visual Importer is a professional program designed to provide an integrated solution for designing and deploying data warehouses. It solves complex problem of integration between different data sources and targets. It combines components of both ETL and design tools into one tool. Visual Importer Professional is a handy pierce of software designed to import data into Oracle, SQL Server, ODBC Databases (Datawarehouses) from flat files or ODBC datasources. Very fast and reliable. Uses native API. In case of errors, Visual Importer Professional writes a detailed message into the log and writes a record into the rejected records file.
Here are some key features of “Visual Importer Professional”:
  • Easy Repository switching
  • Data Preview
  • Mapping editor
  • Exports
  • SQL scripts editor
  • Packages editor
  • Integrated Scheduler
  • Logging
  • Lookups
  • Email Notifications
  • File Operations
  • Check Files
  • Compare Files
  • FTP Downloads
  • Applications
  • Free hand SQL tool
  • Integrated SQL builder
  • Great performance – hundreds of records per second
  • Comprehensive logging
  • Rejected records file
  • Integrated Expressions builder
  • MDAC
  • MS Access ODBC driver
  • FoxPro ODBC driver
  • SQL ODBC driver
  • Oracle Client
  • Interbase client
  • Jet 4.0
  • 30-day trial period
  • Nag screen
What’s New
  • Added snap to grid option
  • Added RichText object to the Report Designer
  • Addded Data Port option to FTP Connection

Tags: ,

Trackback from your site.

Leave a comment