|
 |
|
Learn
More
At the heart of what we do is the mix of art and engineering. The artful experiences that we have make us better engineers. We have taken those that show consistent value in the eyes of our clients and prepared them for repeatability, stability and robustness.
Downloads
ThotWave Corporate Brochure (pdf)
ThotWave Metadata Explorer (pdf)
thinking data Toolkit for Business Intelligence (pdf)
"When I'm working on a problem, I never think about beauty. I think only how to solve the problem. But when I have finished, if the solution is not beautiful, I know it is wrong."
R. Buckminster Fuller (1895 - 1983)
|
|
thinking
data® Toolkit for Data Warehousing
ThotWave’s accumulated intellectual capital from solving countless data
management problems has been transformed into the thinking data®
Toolkit for Data Warehousing. Our collection of SAS® code, scripts, and
best practices are the tools we use to jumpstart our data management consulting
projects.
Applications
- Extraction, Transformation, and Loading (ETL) for data warehouses and data marts
- Operational data stores that integrate data from multiple sources for analytic processes
- Data conversions
- Data quality
- Jump start development of SAS® data management projects with a set of proven, tested components. Support version control, promotion of code between environments, automated unit testing, and other development best practices
Features
- Scripts and best practices for SAS installation and team development
- SAS programs for source data content verification
- Methodologies and SAS macros for loading dimensional (star schema) data models
- SAS macros for managing the approve/reject/hold status of data batches in data marts and warehouses
- General SAS macros covering areas such as data management, print/output formatting, graphics, statistics, and clinical trials management
- XML-based run sequencing mechanism for SAS programs with step restartability and parallel execution
- Production monitoring of SAS jobs using the thinking data® Event System
System Requirements
The thinking data® Toolkit for Data Warehousing is based on cross-platform technologies - the SAS System, Java, and perl.
- Required: the SAS System version 8.2 or better
- Java features require Java SDK 1.3 or better
- Able to use native SAS data sets or work with a large number of relational databases supported by SAS/Access
|
|
