August 16, 2023

tSPSSInput – Docs for ESB 6.x

  2. Talend for ESB Docs
  3. Docs 6.x
  4. tSPSSInput – Docs for ESB 6.x

tSPSSInput

Addresses SPSS .sav data to write it for example in another file.

tSPSSInput reads
data from an SPSS .sav file.

tSPSSInput Standard properties

These properties are used to configure tSPSSInput running in the Standard Job framework.

The Standard
tSPSSInput component belongs to the Business Intelligence family.

The component in this framework is generally available.

Basic settings

Sync schema

Click this button to synchronize with the columns of the input
SPSS .sav file.

Schema and Edit
Schema

A schema is a row description. It defines the number of fields (columns) to
be processed and passed on to the next component. The schema is either Built-In or stored remotely in the Repository.

The schema metadata in this component is retrieved directly from
the input SPSS .sav file and thus is read-only.

You can click Edit schema to
view the retrieved metadata.

Filename

Name or path of the SPSS .sav file to be read.

Translate labels

Select this check box to translate the labels of the stored
values.

Note:

If you select this check box, you need to retrieve the
metadata again.

Advanced settings

tStat
Catcher
Statistics

Select this check box to collect log data at the component
level.

Global Variables

Global Variables

NB_LINE: the number of rows read by an input component or
transferred to an output component. This is an After variable and it returns an
integer.

ERROR_MESSAGE: the error message generated by the
component when an error occurs. This is an After variable and it returns a string. This
variable functions only if the Die on error check box is
cleared, if the component has this check box.

A Flow variable functions during the execution of a component while an After variable
functions after the execution of the component.

To fill up a field or expression with a variable, press Ctrl +
Space to access the variable list and choose the variable to use from it.

For further information about variables, see
Talend Studio

User Guide.

Usage

Usage rule

This component is used as a start component. It requires an output
flow.

Warning:

Before being able to benefit from all functional objectives of
the SPSS components, make sure to do the following: -If you have
already installed SPSS, add the path to the SPSS directory as
the following: SET
PATH=%PATH%;<DR>:programSPSS, or -If you
have not installed SPSS, you must copy the SPSS IO
“spssio32.dll” lib from the SPSS installation CD and paste it in

Talend
 root
directory.

Limitation

Oracle provides two kinds of JVM platforms (32-bit and 64-bit). By
default, the JVM used in a 64-bit operating system is the 64-bit
version of the JVM. Since the JSPSS.dll file used by this component
is compiled in the 32-bit JVM, it is needed to configure the 32-bit
JVM for Job execution in
Talend Studio
 installed on a 64-bit operating
system.

To do so, perform the following:

  1. Open the relevant Job in the workspace.

  2. Click the Run tab and
    enter the Advanced settings
    view.

  3. Select the Use specific JVM
    arguments     check box and click the New… button.

  4. In the Set the VM
    argument     box, enter -d32 and
    click Ok for validation.

Scenario: Displaying the content of an SPSS .sav file

The following scenario creates a two-component Job, which aims at reading each row of
a .sav file and displaying the output on the log console.

Setting up the Job

  1. Drop a tSPSSInput component and a
    tLogRow component from the Palette onto the design workspace.

    Use_Case_tSPSSInput.png

  2. Right-click on tPSSInput and connect it
    to tLogRow using a Main Row link.

Configuring the input component

  1. Click tSPSSInput to display its Basic settings view and define the component
    properties.

    Use_Case_tSPSSInput1.png

  2. Click the three-dot button next to the Filename field and browse to the SPSS .sav file you want to
    read.
  3. Click the three-dot button next to Sync
    schema    . A message opens up prompting you to accept retrieving
    the schema from the defined SPSS file.

    Use_Case_tSPSSInput2.png

  4. Click Yes to close the message and
    proceed to the next step.
  5. If required, click the three-dot button next to Edit
    schema     to view the pre-defined data structure of the source
    SPSS file.

    Use_Case_tSPSSInput4.png

  6. Click OK to close the dialog box.

Job execution

Save the Job and press F6 to execute it.

The SPSS file is read row by row and the extracted fields are displayed on the log
console.

Use_Case_tSPSSInput5.png

Translating the stored values

To translate the stored values, complete the following:

  1. In the Basic settings view, select the
    Translate label check box.
  2. Click Sync Schema a second time to
    retrieve the schema after translation.

    A message opens up prompting you to accept retrieving the schema from the
    defined SPSS file.
  3. Click Yes to close the message and
    proceed to the next step.

    A second message opens up prompting you to accept propagating the
    changes.
  4. Click Yes to close the message and
    proceed to the next step.
  5. Save the Job and press F6 to execute
    it.

The SPSS file is read row by row and the extracted fields are displayed on the log
console after translating the stored values.

Use_Case_tSPSSInput6.png

Document get from Talend https://help.talend.com
Thank you for watching.
Docs 6.x
Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments
0
Would love your thoughts, please comment.x
()
x