Four Stars

Create empty Table for SAP-HANA

Hi,

 

in ETL, I want to create an empty table for an SAP HANA connection with the component tCreateTable. Unfortunately, this component does not offer the database type SAP HANA. Is there a solution for this?

 

Best regards
Achim-OL

2 REPLIES
Moderator

Re: Create empty Table for SAP-HANA

Hello,

Here is a tSAPHanaRow component in talend. It executes the SQL query stated onto the specified database. You can write '

CREATE TABLE BLANK_TABLE' with at least one fileld(no value) in query field.

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.
Four Stars

Re: Create empty Table for SAP-HANA

Hello,

 

thanks for the answer. I had already considered the idea with tSAPHanaRow. But I would like to create a table based on a schema, because the table has a lot of fields, and there can still happen changes. That's why the way through a schema.

 

Best regards

Achim-OL