CREATION OF ADW USING TPT AND JMS ACCESS MODULES

Tools & Utilities
Enthusiast

CREATION OF ADW USING TPT AND JMS ACCESS MODULES

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.


MRANK

7 REPLIES
Enthusiast

Re: CREATION OF ADW USING TPT AND JMS ACCESS MODULES

Hi,

Is there anybody who can help me on above query?

MRANK

Teradata Employee

Re: CREATION OF ADW USING TPT AND JMS ACCESS MODULES

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'

  (

        Associate_Id            INTEGER,

        Associate_Name          CHAR(25),

        Salary                  FLOAT,

        DOJ                     INTDATE,

        Designation             VARCHAR(25),

        Loan_Amount             DECIMAL(5,2),

        Martial_Status          CHAR(1),

        No_Of_Dependents        BYTEINT

  );

  DEFINE OPERATOR JMS_READER ()

  DESCRIPTION 'DataConnector READER'

  TYPE DATACONNECTOR PRODUCER

  SCHEMA PRODUCT_SOURCE_SCHEMA

  ATTRIBUTES

  (

      VARCHAR AccessModuleName,

      VARCHAR EnableScan           ='N',

      VARCHAR AccessModuleInitStr,

      VARCHAR FileName,

      VARCHAR PrivateLogName       = 'JMS001P1',

      VARCHAR OpenMode,

      VARCHAR IndicatorMode        = 'N',

      VARCHAR Format

  );

  DEFINE OPERATOR LOAD_OPERATOR()

  DESCRIPTION 'Load Operator'

  TYPE LOAD

  SCHEMA *

  ATTRIBUTES

      (

        VARCHAR PrivateLogName    = 'JMS001C1',

        INTEGER ErrorLimit        =  1,

        INTEGER MaxSessions       =  32,

        INTEGER MinSessions       =  1,

        VARCHAR TargetTable,

        VARCHAR TdpId,

        VARCHAR UserName,

        VARCHAR UserPassword,

        VARCHAR AccountId,

        VARCHAR ErrorTable1,

        VARCHAR ErrorTable2,

        VARCHAR LogTable

     );

  APPLY ( 'INS JMS001;') TO OPERATOR (LOAD_OPERATOR)

  SELECT * FROM OPERATOR

  ( FILE_READER()

          ATTR(

            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'

            )

   );

);

-- SteveF
Enthusiast

Re: CREATION OF ADW USING TPT AND JMS ACCESS MODULES

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

Mrank

Teradata Employee

Re: CREATION OF ADW USING TPT AND JMS ACCESS MODULES

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.

-- SteveF
Enthusiast

Re: CREATION OF ADW USING TPT AND JMS ACCESS MODULES

Thanks a lot again for the response Feinholz. The information provided is very useful.

Enthusiast

Re: CREATION OF ADW USING TPT AND JMS ACCESS MODULES

Hi Feinholz,

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,

Mrank

Teradata Employee

Re: CREATION OF ADW USING TPT AND JMS ACCESS MODULES

Our access module API only supports access modules written in C.

-- SteveF