HomeForum
Welcome, Guest

Oracle SQL Loader vs. Visual Importer Enterprise ?
(1 viewing) (1) Guest
  • Page:
  • 1

TOPIC: Oracle SQL Loader vs. Visual Importer Enterprise ?

Oracle SQL Loader vs. Visual Importer Enterprise ? 11 months, 3 weeks ago #2839

  • Mike
  • OFFLINE
  • Fresh Boarder
  • Posts: 12
  • Karma: 0
Hi

We are experiencing some difficulties with Oracle SQL Loader, e.g. hanging at the end of an data load. Can you send details on your product and let me know if it can handle loading of data into exiting tables rapidly without using table locking etc.

In other words… would you put your product up against the Oracle SQLLDR product on performance and reliability?

Regards
Mike

Re: Oracle SQL Loader vs. Visual Importer Enterprise ? 11 months, 3 weeks ago #2841

  • admin
  • OFFLINE
  • Moderator
  • Posts: 2191
  • Karma: 12
Try using conventional path loading instead of direct path

Regarding performance SQLLDR will be always faster but it can load data only from the text files.

Visual Importer can load data from Text, XML, Excel, Access, DBF, Foxpro, ODBC, OLE DB, MS Sql Server, Oracle, MySql, PostgreSQL, Firebird, Interbase, SQLite + full support for unicode.

Peter
  • Page:
  • 1
Time to create page: 0.14 seconds

Testimonials

"We used Advanced ETL Processor to give us more flexibility with business automation. And better yet, we always felt that the DBSL support team is a true partner in every sense of the word, assisting us when we needed help"

Carlos Tantis,
Marketing Manager

User Login

You only need to log in or register to use our support forum



Our customers

BP

BBC

HSBC


Databases we work with

Go to top