asked on November 17, 2023
Hi,
We want to try flexmonster for our application but we can't use static SQL the way it is described here:
https://www.flexmonster.com/doc/connect-to-mssql-database/
It's because our DB schema allows users manually editing columns and data in the columns, so we have a bunch of SQLs to get the data and these SQLs are dynamic depending on the DB data, and we just can't get ALL of the data at once in one SQL. So, we wonder if there is any workaround that would allow us to achieve the goal. One idea is if its possible to have code that would create an index with its SQL each time we generate the new SQL in our code. In Flexmonster docs its done only once through UI.
⋅ November 20, 2023
Hello, Nikita!
Thank you for reaching out to us.
Please note that Flexmonster Data Server does not support the described approach for dynamic data querying. However, you can implement your own server endpoints to pass the data from SQL to Flexmonster. Here is the list of other ways to connect to your SQL database:
We recommend checking our documentation page for more information about these approaches, including their advantages and disadvantages: https://www.flexmonster.com/doc/connect-to-relational-database/
Please let us know if one of the suggested alternatives would work for you.
Best Regards,
Maksym
⋅ November 28, 2023
Hello, Nikita!
Hope you are doing well.
We are wondering if you looked through the recommended FDS alternatives for connecting to SQL.
Please let us know if one of them would fit your use case.
Best Regards,
Maksym
⋅ November 28, 2023
Hi Maksym,
Yeah, I was able to achieve the right dynamic behavior by using CSV format. Still having some minor issues, so may ask some questions later on if not able to resolve myself.
Thank you!
⋅ November 29, 2023
Hello, Nikita!
Thank you for the updates.
We are glad to hear that you were able to find a solution for dynamic behavior.
Feel free to contact us if any assistance is required.
Best Regards,
Maksym
