Posts Tagged ‘odbc’

Visual Importer 4.9.5.2

Wednesday, March 10th, 2010


Visual Importer v. 4.9.5.2
Now You Can Load 14,347 Records A Second With The Easy-To-Use Visual Importer ETL

If you regularly export, transform or load database data, Visual Importer ETL is designed to
Save you time.

It does this in three ways:
Time Saver #1: Processing Speed

Using Visual Importer ETL Standard version 4.9.1.4, you can load a delimited text file into
MS SQL Sever via BCP 500000 lines in… 34 seconds!

That`s 14,347.58 records per second.
Time Saver #2 Compatibility and Versatility

Processing speed is important, but it`s not much use if you have to fiddle around with your data to get it into the right format.

So, we made sure Visual Importer works with almost all data formats you might be using.
It works with…

* Multiple Delimited or Fixed width Text files
* Multiple Excel files + Multiple Excel Spreadsheets
* Multiple MS Access Databases + Multiple Tables
* Multiple DBF Files
* Multiple Tables
* MS Sql Server
* Oracle Database
* MySql
* PostgreSql
* Interbase/Firebird
* Any ODBC Database

Visual Importer is a simple ETL tool

And…
The latest version now allows you to load data from Utf8, Utf16BE, Utf16LE files with or without BOM.
There is full support for international characters for ODBC connections, MS SQL Servers and Oracle databases.
Unlike Oracle SQL loader, BCP, DTS or SSIS Visual Importer ETL can also add new and update old records based on user-defined key.

Time Saver #3 Ease Of Use

Because Visual Importer ETL was especially designed for non-technical users, it can be picked up in as little as 10 minutes…

I had my first upload running within 10 minutes of installing Visual Importer ETL”
Gene Kovacs, Director of Technical Business Operations, A2B

Source Data Filtering, Multiple source tables and files. Unlike Oracle SQL loader, BCP, DTS or SSIS, Visual Importer can also add new and update old records based on the user-defined key.

Version: 4.9.5.2

Download Visual Importer now

Visual Importer Professional 7.7.5.2

Tuesday, March 9th, 2010


Visual Importer Professional v. 7.7.5.2
Visual Importer Professional automates loading data into ANY Database from ANY Database or file. Plus automation of business processes such as FTP, Email: POP3 and SMTP, File operations, SQL scripts, Zip and Unzip, ETL Task scheduler and comprehensive logging. Full support for Excel, MS Access, DBF and Text files, Oracle, MS SQL Server, Interbase/Firebird, MySQL, PostgreSQL or any ODBC compliant database.

Here is simple usage example: Download files from an FTP server, load them into the database, run stored procedure or SQL script and send email to the admin, once the package is completed.

One of the major benefits of using Visual Importer Professional that it can also add new and update old records based on user defined primary key.

Let`s say, for example, you work at university and must publish results of exams from different departments. Visual Importer Professional can help you automate data processing without the need for more staff. It will enable you to process data sent via email and FTP without user intervention. Simply create a dedicated email account, design a package and that`s it – start processing data!

Another unique benefit of using Visual Importer Professional its ability to load data from multiple files or tables using mask.

If there is a problem it is very easy to resolve: Every package execution is logged. In case of loading errors, Visual Importer Professional writes a detailed message into the log and writes a record into the rejected records file.

On top of that there are several wizards to make your life easier so you can automate your routine tasks today and spend more time sitting in the bar watching football and drinking beer!!!

Version: 7.7.5.2

Download Visual Importer Professional now

Visual Importer Enterprise 7.7.5.2

Tuesday, March 9th, 2010


Visual Importer Enterprise v. 7.7.5.2
Visual Importer Enterprise automates loading data into ANY Database from ANY Database or file. Plus automation of business processes such as FTP, Email: POP3 and SMTP, File operations, SQL scripts, Zip and Unzip, ETL Task scheduler and comprehensive logging. Full support for Excel, MS Access, DBF and Text files, Oracle, MS SQL Server, Interbase/Firebird, MySQL, PostgreSQL or any ODBC compliant database.

Here is simple usage example: Download files from an FTP server, load them into the database, run stored procedure or SQL script and send email to the admin, once the package is completed. Unlike Oracle SQL loader, BCP, DTS or SSIS, Visual Importer Enterprise can also add new and update old records based on user defined primary key.

Let`s say, for example, you work at university and must publish results of exams from different departments. Visual Importer Enterprise can help you automate data processing without the need for more staff. It will enable you to process data sent via email and FTP without user intervention. Simply create a dedicated email account, design a package and that`s it – start processing data!

Another unique benefit of using Visual Importer Enterprise its ability to load data from multiple files or tables using mask.

If there is a problem it is very easy to resolve: Every package execution is logged. In case of loading errors, Visual Importer Enterprise writes a detailed message into the log and writes a record into the rejected records file.

On top of that there are several wizards to make your life easier so you can automate your routine tasks today and spend more time watching football and drinking beer!!!

The Enterprise version includes execution agent, which can be run as a Windows service.

Version: 7.7.5.2

Download Visual Importer Enterprise now

Model C1D0F252 X12 Parser 1.16C-05

Sunday, March 7th, 2010


Model C1D0F252 X12 Parser v. 1.16C-05
The X12 Parser allows you to convert X12 837 claims
or 835 remittance files into a CSV,XML or DBF files.
It is designed to be used either on the desktop
or can be called from another application to convert
an X12 file. It can be set to convert all the files
in a specified folder.

The X12 Parser can create and populate an SQL table
via ODBC and you can run the Parser from another
application without user intervention.

837 Health Care Claims
277 Claim Status
835 Remittance Advice
997 Functional Acknowledgement
864 Informational Report

Data is displayed in context sensitive screens relative
to their transaction set.

FEATURES
- Can be run from another application using the input
file name as a parameter.
- Mappable Export for 837 or 835 files to CSV,XML
or DBF file formats.
- File Loop Format for faster conversion of large 837 or
835 files to CSV,XML or DBF file formats.
- Generate CMS-1500 from 837 file
- Generate 276 claims status request from 837 file
- Generate a single claim 837 X12 file form an 837
file that contains several claims.
- Format X12 files to text, .rtf, .pdf and .html
- View or Print Listings of Claims
- View or Print Data Sheet of Individual Claims
- View or Print Listings of Remittance
- View or Print Data Sheet of Remittance
- View or Print Functional Acknowledgements
- View or Print X12 Data in segmented lines
- Configurable screen display fields
- Configurable print and listing fields
- HIPAA Compliant X12 Version 4010 and 4010A

Version: 1.16C-05

Download Model C1D0F252 X12 Parser now

Model C1A3F297 Command Line Translator 1.16C-05

Sunday, March 7th, 2010


Model C1A3F297 Command Line Translator v. 1.16C-05
The Command Line Translator has been designed to be a flexible yet practical computer application program for the purpose of giving software developers, systems integrators, and medical billing professions a tool that will allow them to create solutions and solve problems they might encounter in their business processes relative to the scope of Electronic Data Interchange and health care. The Command Line Translator is a cost effective way to add HIPAA X12 electronic claims to an existing system. It can even be used to fix other X12 837 files that no longer meet an insurance carriers specific requirements.

Version: 1.16C-05

Download Model C1A3F297 Command Line Translator now