Ewarenow Quick Query (EQQ) is a web application that obtains live data from your main business application’s database.
Each user must be registered and authenticated to use EQQ. Some will be authorized only to use existing queries. Others can be authorized to create, test, and activate new queries.
By design, EQQ stores its queries, tables, views, and stored procedures in its own database. And it only operates on your business data with SELECT statements – reading the data, but never updating, deleting, or adding data.
It has a high level of security built in so that the privacy and integrity of your data are well-protected. You can enforce secure data transmission (https) to encrypt the data being transferred between the server and users’ workstations, tablets, or smartphones.
- You can map the data to the agency’s precise requirements once in Ewarenow Quick Query and reduce the operational process to less than 10 minutes per week/day to run the query and submit it to the agency.
- With Ewarenow Quick Query, you can craft queries for each customer and then simply run them as needed and send the results to your customers.
- Obtain Conductor from Forcivity, Inc. (https://forcivity.com/). You can download the data from Salesforce to a SQL Server database as frequently as you need.
- Then you can use Ewarenow Quick Query to produce all the query results you want.
- Regrettably, that’s a very common situation. Most business software companies are focused on meeting the common needs of many customers and have great difficulty dealing with specific reporting requests from one customer.
- With Ewarenow Quick Query, you take the software supplier out of the loop. Your own staff can generally write the queries you need; and do so faster than you can get the rejection of your request from the software supplier.
- With Ewarenow Quick Query, one trusted individual can create underlying views of the data that hide the sensitive and private data. Then others can write queries based on those views.
- Ewarenow Quick Query is designed deliberately to treat all application data as Read-Only, providing protection for the integrity of the fundraising data.
- That’s very common and it’s understandable why it’s needed by the requestor and sucks up scarce IT staff time.
- To some extent you can plan ahead for this by making the first query ask for a date range.
- Ewarenow Quick Query helps by making the definition of parameters a key facet of every query creation. The parameters are easy to define and it’s a conscious decision not to define any.
- Every query written in Ewarenow Quick Query is saved in the EQQuery database where it can be found easily.
- And with a little discipline by query creators, each query will have a brief description that will help distinguish similar ones by more than just a unique name
- Ewarenow Quick Query doesn’t actually provide a portal, but it can be the back-end where a qualified Quick Query user can create the needed queries to meet the needs of the portal.
- Then the logic in the portal itself would be very simple: Validate the customer’s login, use the Quick Query queries to populate dashboard graphics, and provide a list of other queries the customer can select and run.
You will probably authorize one or a few people with the equivalent of good Excel expertise to write queries. Most will simply be using those queries as part of their normal work. For them it’s very easy.
Click the link to Ewarenow Quick Query on your browser
You get the Ewarenow Quick Query sign-in page. Enter your username and password and click the Sign In button.
You are at the Use Queries page.
I ask for what seems like a simple Excel spreadsheet and my IT staff tells me it is hard and will take a lot of time. Why is it hard?
Real business applications may have 100-200 tables and an immense number of relationships. Most query creators are not prepared to deal with all the complexity of the relationships.
A person with advanced Excel skills or SQL Server query skills can write a small number of Views in Ewarenow Quick Query to flatten out the data and replace meaningless links with the corresponding real-world text.
We do provide training tools for view creators that have good Excel skills but no SQL skills.
Then people without such advanced skills or training can use the views to write numerous queries.
And your users can simply select queries they need to run, enter a parameter or two and get the results they need.
- Microsoft Visual Studio 2012
- Dot Net Framework 4.5
- C#, ASP Dot Net, Telerik UI, jQuery
- HTML5, CSS3 (responsive)
- SQL Server 2008 R2, 2012
- Microsoft Windows Server 2008 or higher; or Windows 7, Windows 8.1, Windows 10 or higher
- Internet Information Services (IIS) Version 7 or higher
- https recommended; http supported
- SQL Server 2008 R2 or higher
- Operating system: Windows XP, 7, 8.1, 10, Android, iOS
- Browser (latest version) Chrome, Edge, Firefox, Safari, limited support for Internet Explorer