topic Re: Component creation for Teradata Aster in Talend Studio

Component creation for Teradata Aster

mlanciau — Sat, 16 Nov 2024 11:35:37 GMT

Hi
I would like to create component for Teradata Aster.
Teradata Aster is a Database all the function is SQL.
I would like to know what is the best way to start and how to code the component to do like pig integration into Talend (several box leads to a pig script)
Thanks
Kind regards.

Re: Component creation for Teradata Aster

Anonymous — Mon, 21 Jul 2014 20:18:48 GMT

As far as I know for the Asta database you can use the normal PostgreSQL driver and components.

Re: Component creation for Teradata Aster

_AnonymousUser — Tue, 05 Aug 2014 20:45:39 GMT

Hi - I am unable to use my Aster database with the postgresql connector:

Exception in component tPostgresqlInput_1
org.postgresql.util.PSQLException: ERROR: Unrecognized protocol version: 196608
at org.postgresql.core.v3.ConnectionFactoryImpl.doAuthentication(ConnectionFactoryImpl.java:276)
at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:95)
at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:66)
at org.postgresql.jdbc2.AbstractJdbc2Connection.<init>(AbstractJdbc2Connection.java:124)
at org.postgresql.jdbc3.AbstractJdbc3Connection.<init>(AbstractJdbc3Connection.java:30)
at org.postgresql.jdbc3.Jdbc3Connection.<init>(Jdbc3Connection.java:24)
at org.postgresql.Driver.makeConnection(Driver.java:386)
at org.postgresql.Driver.connect(Driver.java:260)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at charterproduct.aster_0_1.Aster.tPostgresqlInput_1Process(Aster.java:685)
at charterproduct.aster_0_1.Aster.runJobInTOS(Aster.java:1246)
at charterproduct.aster_0_1.Aster.main(Aster.java:1111)

Re: Component creation for Teradata Aster

Anonymous — Thu, 04 Sep 2014 20:29:06 GMT

OK my fault. What about the JDBC components, the Asta-DB should carry a JDBC driver and you can use it this way.

Re: Component creation for Teradata Aster

_AnonymousUser — Fri, 28 Aug 2015 09:10:37 GMT

Hi,
I was wondering whether there has been any result.
I try to use the native JDBC client in Talent and it is terribly slow. tJDBCOutput is adding on average 1row/s.
br