Database Applications
SageKey has been building and maintaining business database applications for the desktop and web for
the past 15 years. Our area of focus and expertise is with the Microsoft suite of programming tools,
i.e. Visual Studio, SQL Server, Access, Excel, and ASP.Net.
Easy Access
Many developers base their projects on Microsoft Access, understanding the need for a structured way
to store data while favouring the simplicity of the Access environment. However, as their projects grow,
developers find themselves getting stuck. They need a more powerful solution but are unable or unwilling
to move beyond Access.
At SageKey we use Visual Studio, Microsoft's enterprise software development package, and SQL Server,
a robust and efficient data server capable of handling complex data queries and high load. With these
tools we can help your application reach a wider audience, especially as a web-based application. Plus,
with your application backed by SQL Server, you can add Web Services allowing your data to be accessed
over the Internet on any platform. Expand your application from the web to mobile devices while keeping
your data in a single location.
Stay Informed
With your data in one place you can collect and present information more effectively. Database applications
make it easier to extract any kind of information you can imagine from the data you gather. A database
gives you the tools to look at the data the way you want to, whether your goal is to provide reports
to your users, or to understand how people actually use your application.
We're Agile
We believe in balancing good engineering practices with a nimble, rapid development approach that allows
our clients to interact and steer the design and development process throughout its journey. If you're
not getting the kind of information you need out of your application, we can make changes to the data
being collected or the reports it generates.
SageKey has experience working with a wide range of data sets ranging from small and straight forward to absolutely massive and complex.
Examples of Our Work
SHARE OF VOICE
Advanced indexing and reporting of Yellow Pages advertisement data.
Read More
SageKey was hired in 2010 by the Local search Association (formerly Yellow Pages Association) to expand the existing Yellow Pages Indexing system
into a more robust system that could handle an increased workload, higher throughput and expanded reporting.
Over the course of the next year, the project’s scope continued to expand right up to the release. In the end, SageKey delivered a multifaceted product
consisting of two websites, four windows applications and a dozen windows services.
All of these applications work together to provide a straight forward and easy to use reporting website that allows the end user to make sense of extremely complex data.
Notable Features
- VB.Net
- SQL Server
- Javascript
- Reporting
- FTP
- Automation
IRIS ONLINE
Searchable index of Local Search Association's Yellow Page information.
Read More
In 2004 the Local Search Association (then called the Yellow Pages Association)
asked SageKey to build a complex ASP.Net web-based application with the same functionality
as their existing desktop application. Both the timeframe and budget for the project
were tight.
SageKey put a three-person team on the project and delivered on time and on budget.
The application was presented at a national convention a week later to rave reviews.
The web application was built using asp.Net with a SQL Server backend and gives
users access to terabytes worth of current and historical Yellow Pages data and
files.
Over the years the application has had a lot more functionality added and has gone through
several revisions and versions. It now far surpasses the original application in
every way.
IRIS ONLINE is a paid subscription service provided by the Local Search Association
and access to most of the site requires a password. The entry to the site can be
viewed at irisonline.localsearchassociation.org
Notable Features
- ASP.Net
- VB.Net
- SQL Server
- Mapping
- Reporting
SEGMANAGER
Marketing and sales tracking tool for the financial industry targeted at credit unions.
Read More
SEGManager is a complete marketing and sales tracking application designed exclusively for the financial
industry, but targeted specifically to credit unions. It tracks all aspects of the sales process including sales forecasting, related marketing
events, complete prospect and existing customer profiles, financial statistics, and relevant demographic
information.
Since New Vision hired SageKey to assist them in the development and maintenance of their software SageKey
has completed seven major releases of the software, making it the "Premier" tracking application used
in the Credit Union industry today.
Notable Features
- Microsoft Access
- COM Server
- SQL Server
- Mapping
DIRECTORY CODE REQUEST
Online service simplifying the process of managing thousands of advertisement directories.
Read More
The Local Search Association is the central distrubutor of directory information for its members. In
order to facilitate this across more than 8,500 published directories, each directory must have its
own unique directory code. In the past, this would involve either calling the association directly,
or filling out a paper form and faxing it to them for processing.
When the LSA approached SageKey about automating the process, we were more than happy to help!
Working with LSA programmers and staff SageKey developed a helpful and easy to use online form, simplifying
the process for everyone involved. The website then emailed the standardized, completed form to LSA
staff where it could be verified and entered into the LSA IRIS system. Codes were also embedded into
the emailed form that would allow either LSA staff, or the company that created the request, to return
to the site and make any changes or continue filling out missing information.
Notable Features
- VB.Net
- ASP.Net
- SQL Server
- Reporting