debutant sur talend j'ai besoin d'aide pour me lancer

Five Stars

debutant sur talend j'ai besoin d'aide pour me lancer

Bonjour j'ai un premier  projet à faire dans talend et je galére , pour intégrer une table dans une autre , sachant que la table à un index auto-incremente.

Je n'arrive à rien insérer dans ma table pourtant dans le log c'est pas si mal et le traitement termine par : [Code sortie=0]

 

 

Bref si quelqu'un peux m'aider ce serait cool

MErciCapture.PNGCapture2.PNG

 

Tags (1)

Accepted Solutions
Employee

Re: debutant sur talend j'ai besoin d'aide pour me lancer

That is interesting!

 

This looks fine. Could you please try to do a select from same table using tDBInput after data insert (using same DB connection)? If the data is present in the table, it will show in that query.

 

If that is also working fine, I do not have any clue right now. 

 

Lets check the opinion of @xdshi  also.

 

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved

 

View solution in original post

Highlighted
Five Stars

Re: debutant sur talend j'ai besoin d'aide pour me lancer

Ok thank's i try and i tell you

+++

View solution in original post


All Replies
Moderator

Re: debutant sur talend j'ai besoin d'aide pour me lancer

Hello,

This is an international forum and English is the language we use. Posting in English will allow you to get more visibility and more help. Thanks for your understanding!

Best regards

Sabrina

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Employee

Re: debutant sur talend j'ai besoin d'aide pour me lancer

Hi,

 

    Based on the Google Translate version, I am giving the comment from my end. Could you please check whether you have selected Die on Error Option in your tDBOutput component? Please also make sure that you are commiting the transactions. You can do it either by selecting Auto Commit option in the Advanced Section of tDBConnection component or you can use tDBCommit component (connect it with a On Component Ok with tDBOutput).

 

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved

Employee

Re: debutant sur talend j'ai besoin d'aide pour me lancer

@frdufour 

 

Could you please advise whether you were able to resolve the issue after making the changes suggested by me? If the issue has been fixed, could you please mark this topic as resolved? It will help other Talend community members during their reference.

 

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved

Five Stars

Re: debutant sur talend j'ai besoin d'aide pour me lancer

Hello and thank's a lot

I try like your helping but no insert in my table sql server. Purhaps nothing is red in my disigner

 

When i make a insert sql it's ok but nothing with talend.

I give you the shema on my table sql server

 

 

 

USE [DWACIS]
GO

/****** Object: Table [dbo].[SBASE_EIG_F_ANHISTSAL] Script Date: 07/01/2020 15:36:14 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[SBASE_EIG_F_ANHISTSAL](
[BL_HISTO_ID] [int] IDENTITY(1,1) NOT NULL,
[BL_HISTO_ANNEE] [int] NOT NULL,
[BL_HISTO_MOIS] [int] NOT NULL,
[BL_HISTO_DATE] [datetime2](7) NOT NULL,
[BL_HISTO_CTRID] [int] NOT NULL,
[BL_HISTO_PERID] [int] NOT NULL,
[BL_HISTO_ETAB] [nvarchar](50) NOT NULL,
[BL_HISTO_SECT] [int] NOT NULL,
[BL_HISTO_LIBSECT] [nvarchar](50) NOT NULL,
[BL_HISTO_PERMAT] [int] NOT NULL,
[BL_HISTO_PERNOM] [nvarchar](50) NOT NULL,
[BL_HISTO_PERPRENOM] [nvarchar](50) NOT NULL,
[BRUT] [float] NULL,
[B_PXHEURE] [float] NULL,
[COEFREF] [float] NULL,
[COEFCONV] [float] NULL,
[COEFANC] [int] NULL,
[NB_HEURESTPAYE] [float] NULL,
[B_COUTNET] [float] NULL,
[NB_HEURESASS] [float] NULL,
[CHARGEENPLUS] [nvarchar](50) NULL,
[CATMODIF] [int] NULL,
[NB_JRSTRAV] [int] NULL,
PRIMARY KEY CLUSTERED
(
[BL_HISTO_ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO

 

 

talend.PNGtalend2.PNG

Employee

Re: debutant sur talend j'ai besoin d'aide pour me lancer

Hi,

 

    Could you please share the component screenshot of the tDBOutput component (Please mask the confidential part before sharing)? Have you selected Die on error option in it?

 

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved

Five Stars

Re: debutant sur talend j'ai besoin d'aide pour me lancer

Hello,

Yes i have selected stop with error

What do you think about my shema ?

 

 

talend3.PNGtalend4.PNG

Employee

Re: debutant sur talend j'ai besoin d'aide pour me lancer

That is interesting!

 

This looks fine. Could you please try to do a select from same table using tDBInput after data insert (using same DB connection)? If the data is present in the table, it will show in that query.

 

If that is also working fine, I do not have any clue right now. 

 

Lets check the opinion of @xdshi  also.

 

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved

 

View solution in original post

Highlighted
Five Stars

Re: debutant sur talend j'ai besoin d'aide pour me lancer

Ok thank's i try and i tell you

+++

View solution in original post

Five Stars

Re: debutant sur talend j'ai besoin d'aide pour me lancer

Hello i try my error, i'm looking my result in anover table, houps!!! i'm sorry, it's true in talend when it's green th job is ok !
Tank's you a lot with a very very beginer ++ bye bye+and thank's a lot

2019 GARNER 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

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

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

Self-service Talend Migration: Moving from On-Premises to the Cloud

Move from On-Premises to the Cloud by following the advice of experts

Read Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog