Skip to main content
Announcements
SYSTEM MAINTENANCE: Thurs., Sept. 19, 1 AM ET, Platform will be unavailable for approx. 60 minutes.
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