How to insert into SDA table?

[former_member586258]

Hi there!

I have a remote SQL Server table via Smart Data Access, and it works perfectly for reading data, but as soon as I try to insert any record in it, I receive such error:

"Could not execute 'INSERT INTO <table name>...', ...' SAP DBTech JDBC: [585]: operation is not permitted: remote source is restricted to readonly queries: ..."

Error code says:

585 | ERR_API_OPERATION_NOT_PERMITTED | operation is not permitted

What cause this problem and how I can fix it?

Is problem on local (SAP HANA) or remote (SQL Server) system?

There are almost no info on this forum or google, at least I can't find useful one.

Thanks in advance!

[lbreddemann · Accepted solution]

By just googling for "hana sda read write" I found a couple of blogs, documents and pointers to the documentation, that cover this question.

In fact, there's tons of information available on SDA including youtube videos. Not sure why you didn't see them in your extensive search for answers.

[former_member586258 · Accepted solution]

I use wrong keywords. Thank you a lot!