How to connect to Vertica?

posted on February 16th, 2022

Answered

xwenyi asked on February 16, 2022

Hi,
Vertica is an MPP database with good performance. This DB provides JDBC and ODBC drivers for connection. What's the suggested way to connect this DB? Is it necessary to develop a custom data source by ourselves? Thanks.

Kevin

3 answers

Public

Nadia Khodakivska ⋅ Flexmonster ⋅ February 17, 2022

Hello,

Thank you for reaching out to us.

Kindly note that Vertica is not supported in Flexmonster out of the box.
We suggest these approaches to connect the component to your data source:

Writing a server-side script that returns data in a JSON or CSV format – learn more here.
For .NET Core stack: using Flexmonster Data Server as a DLL, which allows implementing custom data fetching logic – learn more here.
For any stack: implementing a custom server that will retrieve data from your data source and pass it to Flexmonster – learn more here.

Please let us know if it works for you. Feel free to contact us if other questions arise.

Kind regards,
Nadia

Public

Nadia Khodakivska ⋅ Flexmonster ⋅ February 24, 2022

Hello,

Hope you are doing well.

We were wondering if you had a chance to test a suggested approach.

Looking forward to hearing your feedback.

Kind regards,
Nadia

Public

Nadia Khodakivska ⋅ Flexmonster ⋅ March 7, 2022

Hello,

Hope you are doing well.

Just checking in to ask if you managed to connect to Vertica. Could you please let us know if our response helped?

Looking forward to hearing your feedback.

Kind regards,
Nadia

How to connect to Vertica?

3 answers

Please login or Register to Submit Answer