- 8021 Views
- 1 replies
- 0 kudos
How to connect to ServiceNow via JDBC?
Hi all,I'm trying to connect to ServiceNow as a data source to ingest some data to a lake.ServiceNow is a MySQL database underneath, however, I cannot figure out how to connect to it with "regular" MySQL JDBC - has anyone ever tried this?
- 8021 Views
- 1 replies
- 0 kudos
- 0 kudos
Hello @Frank Wagner​ Thank you for posting to Databricks Community ForumIt seems like there is not enough documentation around JDBC connectivitySeems like there are a few commercial connectorshttps://www.cdata.com/drivers/servicenow/jdbc/https://www....
- 0 kudos
- 2781 Views
- 1 replies
- 0 kudos
Unable to construct the sql url as the password is having special characters.
while using the sqlalchemy, unable to connect with sql server from databricks:user='user@host.mysql.database.azure.com' password='P@test' host="host.mysql.database.azure.com" database = "db" connect_args={'ssl':{'fake_flag_to_enable_tls': True}} conn...
- 2781 Views
- 1 replies
- 0 kudos
- 0 kudos
We can use urllib.parse to handle special characters. Here is an example:import urllib.parse user='user@host.mysql.database.azure.com' password=urllib.parse.quote_plus("P@test") host="host.mysql.database.azure.com" database = "db" connect_args={'...
- 0 kudos