topic Re: Connectivity issue with sap hana in Qlik Replicate

Connectivity issue with sap hana

suvbin — Thu, 26 Mar 2020 10:09:07 GMT

I am trying to filter the records for all tables in a schema on a particular column. Say ‘Mandt’ column. Trying to fetch with mandt=100.

so for this I have created two manage connections taking types as SAP Application and SAP Application DB. The first one will take the credentials of sap Hana, connection was successful. In the second endpoint we have a option to mention the client number, so there I have given ‘100’, and also we have a option to provide the first endpoint as a backend dB . The connection was successful, but while fetching the tables in the design mode , it gave me error saying table/view does not exist in this schema.

Any help please on this issue.

Re: Connectivity issue with sap hana

Ola_Mayer — Thu, 26 Mar 2020 19:03:14 GMT

This looks like a problem that should be looked at by support.

Please open a ticket in the support portal https://attunitysupport.qlik.com/login?ec=302&startURL=%2Fs%2F

Re: Connectivity issue with sap hana

suvbin — Mon, 30 Mar 2020 02:17:27 GMT

I don't have the credentials for the the above link or portal to raise a ticket. Can you please give some alternative ... or is there any one else can raise a support ticket on behalf of me.

Re: Connectivity issue with sap hana

Anonymous — Mon, 30 Mar 2020 07:15:25 GMT

What is your backend database?

Re: Connectivity issue with sap hana

suvbin — Mon, 30 Mar 2020 09:48:06 GMT

"SAP Application DB as a source Type" used as the front one . In that we have option for giving backend data base. There i have given S4 Hana credentials for "SAP HANA as as source Type" as a backend database.

Re: Connectivity issue with sap hana

GonzaloPerezPrim — Mon, 30 Mar 2020 18:55:07 GMT

Have you been able to test it successfully?

How you were able to find the right SAP Schema that you need to fill for this type of connection at SAP HANA?

Kind regards

Gonzalo

Re: Connectivity issue with sap hana

suvbin — Mon, 30 Mar 2020 22:40:55 GMT

Hi ,

The schema name was given in the requirement by the company.

SAP HANA test connection was successful. Here there is no field given to fill the schema name. When we are taking this SAP HANA as a backend database for SAP Application (DB) , here there is field to enter the schema name.

So here also in SAP Application (DB) was also successfully connected.

When dragging this ( SAP Application (DB)) endpoint in the design mode, and clicked on the "table selection",

then we are getting error like “Table/view HTG/GC4R_TABLES doesn’t exist”.

Re: Connectivity issue with sap hana

Anonymous — Tue, 31 Mar 2020 07:38:07 GMT

Hi Sandeep,

When you work with SAP HANA, your default should be SAP Application and not the DB option. My assumption is that you are using HANA trigger based.

So create a SAP Application and fill in the required information including the Client which is your MANDT filter. In the SAPApp you don't need to define the schema as the Endpoint retrieves it from the configuration.

So Test the Connection and go ahead and add the required tables.

Let me know if you have specific issues.

Thanks,

Adeeb

Re: Connectivity issue with sap hana

Ola_Mayer — Tue, 31 Mar 2020 12:37:02 GMT

Do you have an account manager that can set up a support account for you?

Re: Connectivity issue with sap hana

suvbin — Tue, 31 Mar 2020 16:15:11 GMT

Hi Adeeb,

Thank you for your response.

We are using the below one's as a front end and backend. so in this scenario , does SAP Application as source will support?

SAP S4 HANA -- application front end

SAP HANA Database -- backend

And the client in the SAP Application or SAP Application (DB) means, it points to the system id of the sap gui , when we try to login . am i right?

https://support.qlik.com/articles/000088430 -- according to this article, why the SAP Application (DB) is modern than SAP Application (DB).

can you please clear on this.

Re: Connectivity issue with sap hana

Sue_Macaluso — Wed, 01 Apr 2020 18:09:22 GMT

@suvbin Hi, if you still need help, there is a way to open a ticket as a guest. I found this video posted by our support team. https://www.youtube.com/watch?v=IUIObDzjTzo&list=PLdnQXZq2xRoBblWlKxGws3WVaJ1GU8S41&index=25 . I hope this helps.

Re: Connectivity issue with sap hana

Wlad_Masi — Wed, 01 Apr 2020 18:26:44 GMT

@suvbin I sent you a private message to talk about your Portal access.

Re: Connectivity issue with sap hana

Sue_Macaluso — Wed, 01 Apr 2020 18:27:05 GMT

@suvbin I am sorry I didn't realize its a different portal. A member of our digital support team will be sending you a private message.