One of our client has asked to write a tpump or tpt program to load (insert/update) data from a java based application. Could you please help me or guide me in doing so. Detailed explanation is given below:
We are receiving json files and converting them to a flat file strucuture using a java program and now we wanted to load the data from this flat file to teradata by invoking a tpump or tpt operator Could you please provide me a basic syntax of how to invoke the utilities from the java program.
TPump and TPT are command-line utilities and are not designed to interoperate with Java. There is a C++ API for invoking TPT operators, and a way to use C/C++ AXSMOD in place of a flat file source or destination, but not Java.
A Java program can use the Teradata JDBC driver.