topic Re: Create empty Table for SAP-HANA in Talend Studio

Create empty Table for SAP-HANA

Achim-OL — Fri, 24 Nov 2017 09:04:22 GMT

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

Re: Create empty Table for SAP-HANA

Anonymous — Thu, 30 Nov 2017 07:51:00 GMT

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

Re: Create empty Table for SAP-HANA

Achim-OL — Thu, 30 Nov 2017 08:15:08 GMT

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

Re: Create empty Table for SAP-HANA

Achim-OL — Mon, 11 Jun 2018 12:55:10 GMT

Hello,

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

Best regards

Achim-OL

Re: Create empty Table for SAP-HANA

Achim-OL — Fri, 27 Dec 2019 10:44:17 GMT

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