Configuring SAP Hana as a Source in DataHub using SQLAlchemy Type

Original Slack Thread

how i add sap Hana config in hear

source:
type: sqlalchemy
config:
# Coordinates
connect_uri: “dialect+driver://username:password@host:port/database”

sink:
# sink configs
below requirement
host:port
user/pass
spectial schema/table

Hey there! :wave:

<@U06TM7M40RK> Can you help with the questions in this thread?

:information_source: Please continue to tag RunLLM (e.g <@U06TM7M40RK>) to have it continue generating responses!

To configure SAP HANA as a source in DataHub using the sqlalchemy type, you need to specify the connection details in the connect_uri parameter. Based on the <SAP HANA | DataHub documentation for SAP HANA>, you can use the following format for your configuration:

source:
  type: sqlalchemy
  config:
    connect_uri: "hana+hdbcli://username:password@host:port/database"

sink:
  # sink configs

Here’s a breakdown of the configuration:

  • hana+hdbcli: This specifies the dialect and driver for SAP HANA.
  • username:password: Replace these with your actual SAP HANA username and password.
  • host:port: Replace these with your SAP HANA host and port.
  • database: Specify the database name you want to connect to.

If you need to specify a particular schema or table, you can use additional configuration options such as include_tables and include_views to filter the tables and views you want to ingest. However, these options are not directly specified in the connect_uri but rather in the broader configuration context.

Would you like more detailed guidance on how to include specific schemas or tables in your configuration?

Sources:

  • <SAP HANA | DataHub documentation for SAP HANA> :+1: 0 button :-1: 0 button :bulb: Hint: Mention @runllm in the thread for followups.

Hi, how did my answer work out for you? Need any more assistance? You can also tag <@U07FV3UHE4D> to let your fellow community members know you’re still looking for guidance.

Hi :slight_smile: ! Did this interaction resolve your issue or do you still require assistance ?

Please tag @ RunLLM if you still need further assistance !

Or tag @Datahub Community Support if you require a person to take a look :slight_smile:

Hope this helps ! ><