I am new to active load and TPT. I am trying for an active load using Teradata evaluation version with TPT. Can anyone help me or provide the below script-
Ø Teradata Parallel Transporter script calling a access module.
Ø An access module script/program reading from a JMS server or from a file.
Your help will be deeply appreciated.
This is a **SAMPLE** TPT script using the JMS access module.
It does not contain complete logon credentials. You must fill in the rest.
And the information provided herein is only for sample purposes and does not imply that the script will run.
It is only being supplied here to show you the general nature of a TPT script using the JMS access module.
DEFINE JOB DATACON_TO_LOAD
DESCRIPTION 'Data transfer using JMSSeries'
DEFINE SCHEMA PRODUCT_SOURCE_SCHEMA
DESCRIPTION 'PRODUCT INFORMATION SCHEMA'
DEFINE OPERATOR JMS_READER ()
DESCRIPTION 'DataConnector READER'
TYPE DATACONNECTOR PRODUCER
VARCHAR EnableScan ='N',
VARCHAR PrivateLogName = 'JMS001P1',
VARCHAR IndicatorMode = 'N',
DEFINE OPERATOR LOAD_OPERATOR()
DESCRIPTION 'Load Operator'
VARCHAR PrivateLogName = 'JMS001C1',
INTEGER ErrorLimit = 1,
INTEGER MaxSessions = 32,
INTEGER MinSessions = 1,
APPLY ( 'INS JMS001;') TO OPERATOR (LOAD_OPERATOR)
SELECT * FROM OPERATOR
FileName = 'TLB1',
OpenMode = 'Read',
Format = 'Formatted',
AccessModuleName = '/opt/teradata/client/lib/libjmsam.so',
AccessModuleInitStr = '-url file:///tmp -icf com.sun.jndi.fscontext.RefFSContextFactory -qcf
ivtQCF -qnm ivtQ -ckfile myChkpt.log -flush yes -tdm no -transx 5 -latency 5 -rwait 1 -logfill yes -log
mylog.log -tlf yes -TRCL 4 mytrace.log -debug yes'
Thanks a lot for the response Feinholz. Can you please help me in providing below information-
Does the teradata 13.0/13.10 version contains inbuilt access modules. If yes, can these access modules be customised for transformation or has to be written separately and then called in TPT script?
Thanks in advance
Teradata does not support internal access modules. All access modules are built to be run on the client machine and called by TPT. Thus, each access module has to be customized.
However, the access module API accepts an initialization string and this is used by access modules to customize behavior based on the contents of the init string.
Thus, you could write an access module that does a whole slew of different types of operations, based on information in that init string.
I have seen that the access module script that is used in this respect is a C program. can you please let me know if it would be compatible if we use a Java script instead.
Thanks in advance,