Despite the COVID-19 outbreak, our team continues operating at full speed. We are always here to support and answer all your questions.

Feel free to reach out by filling this quick form.

Fill the form
Get Free Trial

How can I connect to SQL database?

Cristiane_S asked on February 12, 2016

I want to connect to my Microsoft SQL Server and use a particular table as the data source.
Is it possible to connect directly to the database from Flexmonster Pivot Table without going through a CSV-file.
If yes, is there a guide somewhere I can look at?

1 answer

Antonina Krus Flexmonster February 12, 2016

We have such request very often but answer is still the same – no, there is no such option. Why? Because our component is client-based. This means that there is no server-side part. And you must provide database credentials directly to the component. And, yes, everyone can see them. I think, it’s extremely unsecure.
I recommend you to look at this sample It’s really easy to implement.

Please login or Register to Submit Answer