We recently upgraded from 32 bit, where were able to make a direct connection to a Teradata DW (NYS eMedNY) using the ODBC Teradata driver.
we've just learned that teradata does not supply an odbc driver for hp unix, 64 bit with the RISC processors (our machine).
Therefore we will not be able to connect directly to emedny with our new 64 bit version of informatica (ETL formats the Teradata to be stored in Oracle tables). until such time that a driver becomes available or we upgrade to new machine or processors.
What are our options? The 'old' process was to sign on to the Teradata DW, execute SQL generated by the BI query tool, and save the output to a file on the deskstop or shared drive. The process took hours to complete. The direct connection, took minutes,