SAP Knowledge Base Article - Public

2439218 - "To Connect to SQL databases, ask your system administrator to install database drivers on your system." error in SAP Analytics Cloud

Symptom

The following error message appears while trying to create a new SQL Connection:

  • "To Connect to SQL databases, ask your system administrator to install database drivers on your system."
    SQL.jpg

Environment

Reproducing the Issue

  1. Login to SAP Analytics Cloud.
  2. Go To Connections.
  3. Create a new "import Data Connection" to "SQL Databases".
  4. Notice the error.

Cause

The database driver is not configured.

Resolution

In this example, we follow the steps to configure Microsoft SQL Server 2014:

  1. Download the JDBC driver (.jar file) into a location of your choice:
    SQL2.jpg

  2. Create a file <name>.properties (usually driverconfig.properties) that contains the paths of the different JDBC drivers:
    SQL3.jpg

  3. Create the environment variable (SAP_CLOUD_AGENT_PROPERTIES_PATH):
    SQL4.jpg

The documentation of the product contains these steps along with the supported JDBC drivers.

See Also

Your feedback is important to help us improve our knowledge base.
Please rate how useful you found this article by using the star rating feature at the beginning of this article.
Thank you.

Keywords

Hana Cloud for Planning, Cloud for Analytics, C4P, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, HCP, C4A, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJ, BOBJcloud, BOCloud., BICloud, BO Cloud, connecting, conecting, conectando, conexão, modelo, SBOC, relational, Microsoft, SQL, Server, 2008, 2012, 2014, MySQL 5, Oracle 11, IBM Puredata (Netezza) Service 7 , KBA , LOD-ANA , SAP Analytics Cloud , LOD-ANA-BI , SAP Analytics Cloud - Business Intelligence (BOC) , LOD-ANA-PL , SAP Analytics Cloud – Planning (BOC) , Problem

Product

SAP Analytics Cloud 1.0