Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
Achim-OL
Contributor II
Contributor II

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

Labels (2)
4 Replies
Anonymous
Not applicable

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

 

Achim-OL
Contributor II
Contributor II
Author

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

 

Achim-OL
Contributor II
Contributor II
Author

Hello,

 

Unfortunately, I have always found no solution. Does anyone have an idea?

 

Best regards

Achim-OL

Achim-OL
Contributor II
Contributor II
Author

Hello,

 

I have to create an empty table with Talend-ETL based on an existing schema. The target system is SAP Hana. In the component tCreateTable, the DB system SAP-Hana is not offered even after several years. Does anyone know a solution?

 

Kind regards, Achim-OL