Teradata support?

[Atul]

Hi Gray and all -

 

I'm using ORMLite with some "standard" DB engines (MSSQL, Oracle) and it works well  - thanks for this.

 

Now, we have a requirement whereby our data layer should be able to read/write (basically use ORMLite) to/from Teradata.

 

Question: I didn't notice a Teradata port; does one exist unofficially anywhere? and if not, could you point me in the right direction of just how this might be implemented?

 

Thanks in advance -

 

Atul

[Gray Watson]

On Apr 9, 2013, at 8:29 AM, Atul <atulsm...@gmail.com> wrote:

> Question: I didn't notice a Teradata port; does one exist unofficially anywhere? and if not, could you point me in the right direction of just how this might be implemented?

I've never heard of Teradata and there is not a database type supported by ORMLite natively. However, depending on how strange their SQL is, you should be able to add a handler for it. Internally ORMLite uses classes which extend BaseDatabaseType (http://ormlite.com/javadoc/ormlite-core/com/j256/ormlite/db/BaseDatabaseType.html) to support the various different databases.

http://ormlite.com/javadoc/ormlite-core/com/j256/ormlite/db/BaseDatabaseType.html

A semi up-to-date list of the various methods supported by the database types is here:

http://ormlite.com/docs/database-type

I'd recommend figuring out which database Teradata is based on and extending that database type. Start with the various different field types and go from there.

Once you have your TeradataDatabaseType class, you can create your ConnectionSource with it by passing it into the constructor.
gray

[Atul]

Thank, Gray.

 

This looks promising; I'll give it a shot.

 

Re: Teradata; it's used in MPP and high-volume configurations.  It definitely competes in the "top 5" Enterprise database space.