SQL Query Manager ++ 26.03.21
t is easy to get lost when you want to find and reuse queries that have been used before, and often several tools are included based on which database that are used. SQM++ is developed to have one central interface into your different data sources.
SQM++ has 2 basic purposes,
1. Help you in the work with SQL queries, and 2. Build your own Data warehouse
1 In this interface you can easily test, save and structure your SQL queries. Then it will also be easier to find your SQLs later, change or use them as samples for new queries.
Basic functions:
Add SQLs using a defined connection
Run the SQL to test it
Save the SQL to keep it
Structure your SQLs in different Workspaces (File folders)
Run SQLs to make exports
Run SQLs to alter databases
Copy SQLs between Workspaces
Find SQLs by name or content.
Supported databases are all databases that can be accessed by using a connection string from an OLE DB or ADO DB connection.
It is mostly used with MS SQL server and Oracle (where you need the Oracle client).
In addition, it is well working with Microsoft Dynamics CRM using fetch XML, both on 365 and on premise.
It works also with MS SQL Azure and Text files.
2.
In addition, your queries can be used to create a Data warehouse. You then setup the queries as source for updating tables in the Warehouse, using a Schedule.
SQL Query Manager ++ can help you to build your own data warehouse that can collect data from different sources into one single database. Normally companies have different systems using different databases. It could be that you shall make reports combining data from an ERP system with data from your CRM system. The CRM system could be cloud based.
The task has a SQL source (SQL Query and a connection string) to extract the data that you want to insert to your warehouse table
The task has a target table name and a target connection string
The task has a Schedule. To define how often and when it runs.
