Technology Checklist

Starting at the top, we’re experts in getting data out, cleaning it up, and making it more accessible, using industry-accepted business intelligence and reporting tools:

Sources	Legacy and mainframe data Flat files ERP systems (J. D. Edwards, Great Plains, Oracle Financials, PeopleSoft, et al) DB2 Microsoft SQL Server Oracle Personal databases Sources accessible through ADO/OLE DB/ODBC Mainframes OS/400, AS/400 UNIX Microsoft Windows NT/2000
ETL (Extract, Transformation, and Load)	DTS Data Junction Rapid Data Data Mirror Cognos Decision Stream Microsoft BCP SQL*Loader Custom code
Targets	Microsoft SQL Server Oracle DB2 Microsoft Windows NT/2000 UNIX
Business Intelligence & Reporting Tools	Custom web applications Crystal Reports Cognos Microsoft OLAP Services MicroStrategy Business Objects Office automation: Microsoft Access, Excel, Word
Underneath all these ways of integrating and accessing data lies a whole range of technologies and tools that we know well. On each engagement, we take advantage of the ones that make the most sense for the job:
Development Tools	SQL Plus, Query Analyzer, other DBMS tools ERwin Microsoft Visual Basic, VBScript, Visual Studio, Visual Safe Source Microsoft OLAP Services Microsoft FrontPage Adobe Photoshop and other graphics packages
Languages	SQL, T-SQL, PL/SQL XML, XSL, XSLT, XPath, XML DOM ASP HTML CSS/DHTML JavaScript C#
Standards	CSS/DHTML COM, DCOM, COM+ HTTP, HTTPS, SSL SOAP OLAP
Microsoft Application Servers	IIS BizTalk Commerce Server Exchange Server
Infrastructure	Precise SQL SQL*Net Microsoft .NET Microsoft Hailstorm MTS, MSMQ VPNs ADSI Authentication and encryption Browsers Internet Explorer Netscape

How do we pick? We love using IIS and ASP to build web-enabled information systems. On the other hand, we’re open and free to using Crystal Reports, Visual Basic, or C# when it’s more appropriate for our clients’ environments. Thus, we can apply any of these tools when they best address the problem, on a case-by-case basis.