TABLE OF CONTENTS
SQL Importer
This article covers the features that are unique to the SQL Importer. For features common to all importers, please see this article.
Supported Databases
- SQL Server
- Dataverse
- MySQL
- PostgreSQL
- MongoDB
- Access
SQL Server
SQL Server is a relational database management system (RDBMS). It's designed to store, retrieve, and manage data efficiently especially for enterprise-level applications.
Managmentstudio can read from the SQL server database.
Dataverse
Microsoft dataverse is a cloud based data platform that allows you to securely store, manage and integrate data used by business applications - especially those built with the Microsoft Power platform like power Apps, Power Automate and Power BI. Managementstudio has the ability to read and bring in these secure information.
MySQL
MySQL is a popular open-source relational database management system (RDBMS). It’s widely used for storing and managing data in web applications, enterprise software, and more. Originally developed by MySQL AB, it’s now owned and maintained by Oracle Corporation.
PostgreSQL
PostgreSQL (often called Postgres) is a powerful, open-source object-relational database management system (ORDBMS) known for its robust features, extensibility, and standards compliance. It’s widely used by developers and enterprises for everything from small apps to large-scale data systems.
MongoDB
MongoDB is a NoSQL, document-oriented database that stores data in flexible, JSON-like documents. It’s designed for scalability, high availability, and ease of development.
ManagementStudio can read from a MongoDB as long as the data is returned in a strict key-value pair array format.
MongoDB requires the mongosh.exe to be accessible from the MS IIS server. Put the folder path to the mongosh.exe in the Aux Param 1 field.
Paging is not currently supported.
Example Query
Note the 'JSON.stringify' at the beginning and the .toArray() at the end.
JSON.stringify(db.tests.aggregate([{$project: {Name: '$Data.__value.Name', UniqueId: '$Data.__value.UniqueId', _id: 0}}]).toArray()) // Expanded for clarity JSON.stringify(db.tests.aggregate( [ { $project: { Name: '$Data.__value.Name', UniqueId: '$Data.__value.UniqueId', _id: 0 } } ] ).toArray())
Microsoft Access DB
A Microsoft Access database is a file-based relational database system used to store, manage, and query structured data. It combines a database engine (Jet/ACE), a user interface, and development tools in a single .mdb
or .accdb
file.
ManagementStudio can read from a Access DB as long as it can see the file location of the DB.
When configuring the Access Connector, put the path to the DB in the "DB Server" field and the file name of the DB in the "DB Name" field.
Example:
Further Support
If you require further support, please visit ManagementStudio's Service Desk to search the knowledge base or create a new support ticket.
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article