|Subject:||A SQL query/designer tool for Mimer|
|Creation date:||3/15/21 10:37 AM|
|Last modified on:||6/25/21 12:36 PM|
You will need to fill out the following fields:
|ODBC Data Source Name||This is a friendly name you want to apply to this Data Source.|
|Data Source Description||Enter a description for this Data Source|
|Mimer SQL Database||Select the Mimer database you want to connect to.|
Once you specify your credentials, click the "OK" button at the bottom.
Now that we are successfully connected, we can begin running queries and modifying the database.
For example, I am adding a person with a specific calorie intake:
If I browse the data I can see the newly added person:
Once you are connected to your Mimer in WinSQL, you will be able to see all of your tables and data within WinSQL. To begin importing data directly from Microsoft Excel, simply drag and drop the .xlsx file directly into your Tables section as seen here:
Using your query tool you can interact with Mimer easily. The benefit is that you also get the entire suite of your chosen tool as well as a much more informative interface. Using WinSQL allows you to use several additional reporting and querying tools that are otherwise not available. Please see here for a list of features/benefits.