As orgs get better at integrating and sharing resources between teams, we increasingly have scenarios where you can’t just log out & in with another ID – rather you need to simultaneously connect to services in different domains, e.g. ![]() Why?Ī large organisation using Active Directory often uses a separate domain for each division of their organisation, and likely also separate domains for development and production resources & environments. I’ll describe a workaround for one such issue here. As Mac adoption increases, and with new developers starting their first job on Macs, some very niche issues – the sort that would affect less than 0.01% of the workforce, who were probably expert enough to deal with it – have become common problems affecting entire teams. Nowadays, MacBooks are becoming increasingly common in large orgs as an option for all staff. There is a tutorial from available: Connect Using the SAP HANA JDBC Driver as a part of the tutorials mission Use Clients to Query an SAP HANA Database.In the old days, the only place you’d find a Mac in a large organisation was in the design team – they’d be self-supported and incompatibility issues with the rest of the Windows org would be an unavoidable fact of life. …or you can use cacerts delivered in some other %JAVA_HOME%, like with SAP JVM in my case. You use the default JRE installed with DBeaver… So let’s check if it can be used to provide the trustStore property for our JDBC connection instead. usr/local/Cellar/openjdk/13.0.2+8_2/libexec/openjdk.jdk/Contents/Home I have another Java installation on my Mac: Personally, I certainly would like to double-check, if these assumptions are correct. cd /Applications/DBeaver.app/Contents/Eclipse/jre/Contents/Homeīin/keytool -exportcert -cacerts -v -alias "digicertglobalrootca " -rfc -storepass changeit The complete JRE is included in the DBeaver installation.Īnd by default JRE comes with the cacerts store of root certificates. What is different with DBeaver? It is a Java app and it is using the JDBC driver. And you might remember that on MacOS or Linix we had to explicitly use that certificate with HDBSQL. We are on MacOS… Have we missed anything?Īgain, if you read the previous post, then you might remember that “ DigiCert Global Root CA” root certificate was required to authenticate SAP HANA host to establish secure communication. Never use admin user, like DBAdmin, to do your work!Ĭreate separate users for admin or for development. Type true there.īingo! Now I can connect and work with my instance. Instead, I added encrypt property, and then (it took me half an hour to figure our) double-click next to my property in Value column to edit. Unfortunately, DBevar did not allow me to put encrypt=true just right here. ![]() Switch to Driver properties and right-click on User Properties to add a new property. Unfortunately, this is where I found DBevaer UI somewhat unintuitive. Let’s add this encrypt parameter to the connection. “ Receive of connect failed.“? Why? Of course, you know, if you read the previous post □Ĭlients can establish only secure connections to SAP HANA Cloud! Plus populate Username and Password fields. This will automatically populate the JDBC URL. So, I need to put Host and Port accordingly to the endpoint copied from my HANA Cloud instance cockpit. If needed, you can still point to a driver you might have pre-install on your machine already.
0 Comments
Leave a Reply. |