No options available for database table to export to.

Question

question

Gerald asked Jun 26, '23 Jordan Johnson answered Jun 29, '23

No options available for database table to export to.

I am attempting to push a global table to a Microsoft SQL studio database using a successfully connected Database connector. I use Flexscript to push the table at the end of the simulation, but I have realized I should be able to set this up using the connector only and the export tab. However, the list shows no options when attempting to set up the table that will be pushed to the database. It suggests testing the connection, which I have done successfully, but no table options are showing up. Any help will be greatly appreciated.

Software Version:

FlexSim 22.2.0

database database connector

· 2

Kavika F ♦ commented · Jun 26, 2023 at 05:42 PM

Hey @Gerald, from what I understand, you were able to successfully connect your SQL Database to FlexSim; however, you can't see any Global Tables in the export tab? What happens when you go to the Database Connector > Export tab and click the Green + button to add a Global Table? Do any show up?

0 ·

1687801326860.png (39.6 KiB)

Julie Weller commented · Jun 29, 2023 at 07:30 PM

Hi @Gerald,

We haven't heard back from you. Were you able to solve your problem? If so, please add and accept an answer to let others know the solution. Or please respond to the previous comment so that we can continue to help you.

If we don't hear back in the next 3 business days, we'll assume you were able to solve your problem and we'll close this case in our tracker. You can always comment back at any time to reopen your question, or you can contact your local FlexSim distributor for phone or email help.

0 ·

Answer 1 · 2023-06-29T21:33:38Z

Jordan Johnson answered Jun 29, '23

Based on the code found in the library:

MAIN:/project/library/DatabaseConnector>behaviour/includebody, L165

It looks like we only generate the list of possible tables for MySQL, Oracle, SQLite, and PostgreSQL. It looks also like there's a default query that it tries, if the connection is other than one of those types. So it's very possible that the queries that generate the list of tables/columns for that button aren't correct given your connection type.

However, if you already generated the query you need, you can just use that query in the export tab. The list of tables/columns is not required for a successful connection.

question