Forum Discussion

mohamadelmardin's avatar
mohamadelmardin
New Contributor III
9 years ago

Is there a generic snap or snap pack to use and connect against different RDBMS systems

I guess I know the answer is NO but I wanted to verify whether we need to buy a snap pack for every RDBMS system we need to connect against or if there is a general one with can configure for multipl...
pavan's avatar
pavan
Former Employee
9 years ago

In addition to the above information, I would like to provide additional information. JDBC Snap Pack can be used as a general means to connect to various databases, but it does come with the following limitations:

  1. It does not provide bulk operations you may require for fast loading or unloading.
  2. Not ideal if you are looking for high performance.
  3. There are limited set of Snaps available for JDBC Snap Pack (Execute, Insert, Select and Update).
  4. You might need more configuration or settings that needs to be done.

We have dedicated Snap Packs for SQL Server, MySQL, Teradata and many other databases. All these Snap Packs have comprehensive functionality coverage that will let users quickly perform various operations on the data (includes bulk operations) and can also address moving large amounts of data. With Teradata we have added TPT functionality and it comes with high performance.