Dear visitor, despite all the challenges, our team continues operating at full speed.

We are ready to help with any questions you may have. Please fill out this quick form and we'll get back to you.

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

Public
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 http://www.flexmonster.com/doc/connecting-to-relational-database-with-net/. It’s really easy to implement.

Please login or Register to Submit Answer