How can I connect Matlab2023B for Apple Silicon DatabaseToolbox App to Cloud.Timescale.com?

Hi, asking your kind help in the following:

How can I connect Matlab2023B for Apple Silicon DatabaseToolbox App to Cloud.Timescale.com?

I installed postgresql-42.6.0.jar and with using the Connect button in the Database Toolbox app, I select this file which I placed in a map named users/myownusername/drivers/postgresql-42.6.0.jar

I use: Database Toolbox app --> Connect --> New JDBC Data Source --> PostgreSQL.

The first highest field to fill in says name: I just created the name of my project within Timescale but it was told to me I can just use whatever name for this.

The second highest field is a dropdown menu: I choose PostGreSQL

The third highest field asks me for the Driver Location: I select the path as descrivd above in this mesage.

users/myownusername/drivers/postgresql-42.6.0.jar

Then 3 to fill in parametes for: Connection Parameters:

Database: I copy/past the database name as shown in the connection details page of my Timescale account: "tsdb"

Server: I copy/past the database name as shown in the connection details page of my Timescale account: "Service URL" --> postgres://tsdbadmin@.........................................

Port number: I copy/past the port number as shown in the connection details page of my Timescale account

Then connnection Options:

I use row 1: (Name: sslmode) (Value: require)

Then I press the Test button to connect:

Username: tsdbadmin

Password: My password as I have this for my Timescale account, just the only one I have to enter my accont at their website

I am sure I am missimg something,

help is apeciated, I ran out of thinkng options, within my limited knowledge as a newbe in Matlab.

Thanks, have a great day,

Wouter

Answer 1

[Anshuman]

Hi Wouter, most of the steps that you have mentioned looks right but here are few things that you can verify to troubleshoot any issues that you are facing:

• You've already placed the "postgresql-42.6.0.jar" in the directory "users/myownusername/drivers/". Make sure that MATLAB has the required permissions to access this directory.
• White setting up the "Connection Parameters", in the 'Server' field, you should enter the server's hostname or IP address, not the entire service URL. If your service URL is something like "postgres://tsdbadmin@hostname:port/tsdb", you should only input "hostname" here.
• Verify that the hostname and port number are correct and that the Timescale cloud service is up and running.

Please share if you getting any specific error messages, those will be key to understanding what might be going wrong.