[[["易于理解","easyToUnderstand","thumb-up"],["解决了我的问题","solvedMyProblem","thumb-up"],["其他","otherUp","thumb-up"]],[["很难理解","hardToUnderstand","thumb-down"],["信息或示例代码不正确","incorrectInformationOrSampleCode","thumb-down"],["没有我需要的信息/示例","missingTheInformationSamplesINeed","thumb-down"],["翻译问题","translationIssue","thumb-down"],["其他","otherDown","thumb-down"]],["最后更新时间 (UTC)：2025-08-25。"],[],[],null,["# SAP HANA\n\nThis page contains information about connecting Looker to SAP HANA and SAP HANA 2+.\n\nEncrypting network traffic\n--------------------------\n\nIt is a best practice to encrypt network traffic between the Looker application and your database. Consider one of the options described on the [Enabling secure database access](/looker/docs/enabling-secure-db-access) documentation page.\n\nCreating the Looker user\n------------------------\n\nCreate a Looker database user with a secure password. \n\n CREATE USER LOOKER PASSWORD \u003cSOME_PASSWORD\u003e\n\n### Granting permissions\n\nGrant read permissions on the schema(s) that you would like to use in Looker. \n\n GRANT SELECT ON SCHEMA \u003cYOUR_SCHEMA\u003e TO LOOKER\n\n### Setting up a PDT schema\n\nIf using PDTs, create a scratch schema for PDTs to be written into. \n\n CREATE SCHEMA LOOKER_SCRATCH OWNED BY LOOKER\n\nCreating the Looker connection to your database\n-----------------------------------------------\n\nIn the **Admin** section of Looker, select **Connections** , and then click **Add Connection**.\n\nFill out the connection details. The majority of the settings are common to most database dialects. See the [Connecting Looker to your database](/looker/docs/connecting-to-your-db) documentation page for information. Some of the settings are described next:\n\n- **Name**: The name of the connection. This is how you will refer to the connection in LookML projects.\n- **Dialect** : **SAP HANA** or **SAP HANA 2+**.\n- **Port**: The database port. The default port is 30015.\n- **Host**: Hostname.\n- **Database**: The name of your database.\n- **Username**: The database username.\n- **Password**: The user password.\n- **Schema**: The default schema to use when none is specified. Entering a schema is optional.\n- **Enable PDTs** : Use this toggle to enable [persistent derived tables (PDTs)](/looker/docs/derived-tables#persistent-derived-tables). This reveals additional PDT fields and the [**PDT Overrides**](/looker/docs/connecting-to-your-db#pdt-overrides) section for the connection.\n- **Temp Database**: Schema to use for PDTs.\n- **Additional JDBC Parameters** : Any additional [SAP HANA JDBC connection properties](https://help.sap.com/viewer/0eec0d68141541d1b07893a39944924e/2.0.02/en-US/109397c2206a4ab2a5386d494f4cf75e.html).\n- **Maintenance Schedule** : A [`cron`](https://en.wikipedia.org/wiki/Cron#CRON_expression) expression that indicates when Looker should check [datagroups](/looker/docs/caching-and-datagroups#specifying_caching_policies_with_datagroup_parameters) and PDTs. Read more about this setting in the [Maintenance Schedule](/looker/docs/connecting-to-your-db#pdt_maintenance_schedule) documentation.\n- **SSL**: Check to enable SSL.\n- **Verify SSL**: Check to enforce strict hostname verification.\n- **Max connections per node** : The default is 25. This value can be left at the default value initially. Read more about this setting in the [Max connections per node](/looker/docs/connecting-to-your-db#max_connections) section of the **Connecting Looker to your database** documentation page.\n- **Connection Pool Timeout**: The default is 120 seconds.\n- **SQL Runner Precache** : To cause SQL Runner not to preload table information and to load table information only when a table is selected, clear this option. Read more about this setting in the [SQL Runner Precache](/looker/docs/connecting-to-your-db#sql_runner_precache) documentation.\n- **Database Time Zone** : Specify the time zone used in the database. Leave this field blank if you do not want time zone conversion. See the [Using time zone settings](/looker/docs/using-time-zone-settings) documentation page for more information.\n\nTo verify that the connection is successful, click **Test** . See the [Testing database connectivity](/looker/docs/testing-db-connectivity) documentation page for troubleshooting information.\n\nTo save these settings, click **Connect**.\n\nTest the connection in SQL Runner. Navigate to [SQL Runner](/looker/docs/sql-runner-basics), select your connection and schema, and then [check if you can see your database tables](/looker/docs/sql-runner-basics-manage-db#getting_table_information).\n\nFeature support\n---------------\n\nFor Looker to support some features, your database dialect must also support them. The following sections show the feature support for [SAP HANA](#sap_hana) and [SAP HANA 2+](#sap_2_hana).\n\n### SAP HANA\n\nSAP HANA supports the following features as of Looker 25.14:\n\n\n### SAP HANA 2+\n\nSAP HANA 2+ supports the following features as of Looker 25.14:\n\nNext steps\n----------\n\nAfter completing the database connection, [configure authentication options](/looker/docs/getting-started-with-users)."]]
