Create empty Table for SAP-HANA

Five 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

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.
Five 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

 

Five Stars

Re: Create empty Table for SAP-HANA

Hello,

 

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

 

Best regards

Achim-OL

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

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

Definitive Guide to Data Integration

Practical steps to developing your data integration strategy.

Download