SPSS file

Highlighted
Four Stars

SPSS file

Please can anyone help me i really need it

 

 

Load Data into database mysql from file spss

i already do for excel file.

help me please

Highlighted
Community Manager

Re: SPSS file

Hi
Take a look at the SPSS components and learn the scenario.
https://help.talend.com/reader/1lUpv~2pBEhtc6fvQwPFhw/US~IomevrLc7LZecQZ24nQ

Regards
Shong
----------------------------------------------------------
Talend | Data Agility for Modern Business
Highlighted
Four Stars

Re: SPSS file

oh thank your reply
i think i can already do that
1°) How to dysplay an spss file
2°)how to write in an.sav file

so my question is :
i have an spss fil and i want to integrat the data into MySQL table database
Best regards
Highlighted
Community Manager

Re: SPSS file

Hi
Are you able to read data from an .sav file now? If not, follows the scenario using tSPSSInput component in this documentation page and learn it.
https://help.talend.com/reader/1lUpv~2pBEhtc6fvQwPFhw/aqcDs4HDZ~uySbMUYGRcZQ
After you read the data from .sav file, link the tSPSSInput component to a tMySQLOutput for inserting or updating the data to Mysql database. eg:
tSPSS--main--tMysqlOutput

Regards
Shong
----------------------------------------------------------
Talend | Data Agility for Modern Business
Highlighted
Four Stars

Re: SPSS file

hi i am so happy for your help
so definitely i have an error please look at the files attached

My spss file contains named variables from A to H
I want to put each group of variables in a mysql table
for example (file attached =captureBD)

Best regardsCapture1.JPGCaptureBD.JPGerreur.JPG

Highlighted
Community Manager

Re: SPSS file

Hi bayeManel
I have no idea on the NPE error, it is not a job design issue, if you are a Java developer, you can launch the Java debug model and debug the Java code to see if you could find any hits.

Snipaste_2020-04-07_10-40-31.png

Regards
Shong

----------------------------------------------------------
Talend | Data Agility for Modern Business
Highlighted
Moderator

Re: SPSS file

tsspinput component is giving null pointer exception..
You need to share the configuration of tsspinput, have you not specified something like host or port or username or password or object name.
Manohar B
Don't forget to give kudos/accept the solution when a replay is helpful.

2019 GARTNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

Best Practices for Using Context Variables with Talend – Part 1

Learn how to do cool things with Context Variables

Blog

Migrate Data from one Database to another with one Job using the Dynamic Schema

Find out how to migrate from one database to another using the Dynamic schema

Blog

Best Practices for Using Context Variables with Talend – Part 3

Read about some useful Context Variable ideas

Blog