Component creation for Teradata Aster

[mlanciau]

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.

[Anonymous]

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

[_AnonymousUser]

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)

[Anonymous]

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

[_AnonymousUser]

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