Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Not applicable
‎2014-11-04 05:29 AM

SAP Connector: Oracle vs MS SQL

Hi,

we use SAP connector and recently our SAP system database has been migrated from Oracle to Microsoft SQL. Since then the performance of SAP connector and uses almost all CPU from the SAP server.

Does SAP connector needs to be reinstalled or configured because of the database change?

1,130 Views
0 Likes
4 Replies
Peter_Cammaert
Partner - Champion III
Partner - Champion III
‎2014-11-04 05:46 AM

Your SAP Connector is not running on the SAP backend, is it?

508 Views
0 Likes
Not applicable
‎2014-11-04 05:53 AM
Author

In response to Peter_Cammaert

Correct. SAP connector runs on our server and SAP is hosted elsewhere outside our network.

One job is running fine but another one next to it (same job other similar company), causes CPU problems

508 Views
0 Likes
Peter_Cammaert
Partner - Champion III
Partner - Champion III
‎2014-11-04 06:41 AM

In response to

Sounds like an SAP configuration problem. Or a DB with bad or missing Indices...

In theory, SAP Connector interfaces to SAP, always. The connector never connects straight to the DB Engine.

508 Views
Anonymous
Not applicable
‎2014-11-10 04:58 PM
Author

Did you solve the problem?

508 Views
0 Likes