SQL Importer

Modified on Fri, 15 Aug at 12:56 PM

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

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article