Skip to Content
author's profile photo Former Member
Former Member

HANA Import from/Export to current client

Hello Comunity,

When I'm trying to import CSV data to my HANA Database then I get an error that the path specified cannot be found. The path exists on my current client(application) and the database is on the remote database server.

Is it not possible to import data remote?

I have also tried to export data from database server and when I choose export table to current client with local location, I get an error " SAP DBTech JDBC: [259]: invalid table name: #IMPORT_EXPORT: line 1 col 20 (at pos 19)"

Where can I find the export script? Have you any idea how can I solve this problem?

Thank you.

Michael

Edited by: Mychajlo Wolowyk on Nov 26, 2011 7:00 PM

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Best Answer
    Posted on Nov 26, 2011 at 08:57 PM

    Hello,

    Is it not possible to import data remote?

    That is exactly your problem. IMPORT operation is happening on server and it does not matter from where the command came (if locally or remotely).

    If you wish to load data remotely you might use series of INSERT statements that can be executed either in HANA Studio or in hdbsql commandline interface that is part of HANA Client.

    I have also tried to export data from database server and when I choose export table to current client with local location, I get an error " SAP DBTech JDBC: [259]: invalid table name: #IMPORT_EXPORT: line 1 col 20 (at pos 19)"

    Where can I find the export script? Have you any idea how can I solve this problem?

    Can you please be more specific how exactly you are trying to export table? Are you using EXPORT statement or via HANA Studio? What is revision of your HANA Database and HANA Studio? What do you exactly mean by "Where can I find the export script"?

    Please be sure to check SAP HANA - SQL Reference Guide (page 112 - EXPORT, page 118 - IMPORT, page 119 - IMPORT FROM):

    https://service.sap.com/~sapidb/011000358700000604922011

    Tomas

    Add a comment
    10|10000 characters needed characters exceeded

    • Hello,

      another option for loading CSV files seems to be Information Composer which should allow to load the file from the end user notebook. (I am in the process of installing it so I will know more after the weekend.)

      However purpose of Information Composer is not to populate HANA tables - it is very likely you will not be able to influence where the table will end up and what exactly will be data definition. (Application is designed for business users with minimal technical background.)

      Tomas

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.