FileMaker and Teradata Intetgration

[Deepak Kumar]

Hi All,

I have need to connect to a Teradata source to view (read-only) or import data into a single table of hosted FileMaker Pro database. Although Teradata provides ODBC drivers for most platforms, there is no such driver for the Mac. Actual technologies makes approved ODBC drivers for FileMaker, but nothing approved for Teradata. 

Perhaps someone here can share their experience and provide some advice and tips on how to best implement this connection, and whether it is via the unofficial ODBC drivers for other SQL sources, or using the Teradata JDBC.

Thanks in advance.
 

[Wim Decorte]

Teradata ODBC driver for Mac OSX: https://downloads.teradata.com/download/connectivity/teradata-odbc-driver-for-mac-os-x

With that you can import into a FM table and work with the data,

[Deepak Kumar]

Can i check whether it does give a real time data?

[Wim Decorte]

Not sure what you're asking...

But if you are asking about ESS: you can not use ESS with teraData.  It is not one of the supported databases.  So you have to an import every time you want to see the data.