Monday, December 19, 2011

Migrating Projects between SQL Power Community Edition and Enterprise Edition software

In response to frequently asked questions along the lines of...

  • What happens to my projects if my Enterprise license expires?
  • Can Community Edition Projects be used in the Enterprise Edition?
  • Can Enterprise Edition Projects be used in the Community Edition?

...Here's how Community/Enterprise projects are handled in SQL Power Architect and SQL Power Wabit:

  1. Architect/Wabit Projects created in the Community Edition can be migrated to Enterprise Edition.
  2. Architect/Wabit Projects created/saved in Enterprise Edition are stored in the Enterprise server database and cannot be accessed by the Community Edition.
  3. When an Architect/Wabit Enterprise license (or free trial period) expires, the Enterprise server database and any projects therein are "locked out" (they are still there, but not accessible) until a license is obtained/renewed.

Note: For SQL Power DQguru, all Projects can be created by/accessed by either Community or Enterprise version.

Friday, November 18, 2011

Demo: End-to-End XBRL Platform

SQL Power's Zero-Footprint End-to-End Supervisory XBRL Platform

This is a very brief demo of SQL Power's web-based end-to-end integrated solution for XBRL data collection, taxonomy management and analytics.

learn more at

Wednesday, November 2, 2011

Zero-Footprint End-to-End XBRL Platform

SQL Power's Zero-Footprint End-to-End Supervisory XBRL Platform


This brief video outlines the challenges of traditional financial regulatory systems and introduces SQL Power's solution: the world's first web-based end-to-end integrated solution for XBRL data collection, taxonomy management and analytics.

learn more at

Friday, September 2, 2011

Using SQL Power Software with MS Access, .csv, flat file, spreadsheets, etc.

Lately, many people have been emailing us at SQL Power Software, asking how to access flat files instead of databases - so I thought I'd take a minute to talk about the subject.

The bad news is that SQL Power software does not support flat file access out of the box. (SQL Power Architect, Wabit and DQguru are high-performance data tools, designed to work with large, industrial-size databases and data models - not excel files.)

HOWEVER: the good news is that since we use JDBC for data access, you can in fact connect to ANY data source, providing you have a working JDBC driver for that data source.

For example: want to connect to a .csv file? Just search for a "csv JDBC driver".

As we don't do a lot of flat-file work ourselves, we'd love to hear about your experiences with these situations. (Especially if you've come across a particularly good JDBC driver for a certain flat file type, so we can recommend it to others.)

For more on this topic, see the SQL Power Frequently Asked Questions:
Spreadsheets & Flat Files
Microsoft Access JDBC-ODBC bridge
Configuring JDBC Drivers

Friday, April 8, 2011

XBRL Canada IFRS Taxonomy Workshop - April 20, 2011

This event is hosted by XBRL Canada, a not-for-profit consortium of leading Canadian companies and organisations, whose role is to create and maintain XBRL taxonomies based on Canadian reporting standards, to increase the awareness, knowledge and understanding of XBRL and its uses in Canada and to stimulate and promote the adoption of XBRL in Canada. XBRL Canada is a jurisdiction of XBRL International.

Date: April 20, 2011
Time: 8:30am - 3:30pm ET
Location: Office of the CICA 277 Wellington St. West, Toronto, ON
Instructor: Eric E. Cohen, PriceWaterhouseCoopers

Breakfast at 8:00 am ET (coffee, juice and muffins will be provided)

Registration fee: $299 CDN

Thursday, April 7, 2011

The Business Intelligence Forum - May 26 2011

The Business Intelligence Forum
May 26 2011 8am-noon at the Hilton Toronto
Presented by MicroStrategy

The Business Intelligence Forum offers a unique, interactive environment to gain technical insights to enhance your business intelligence initiatives and view groundbreaking BI demonstrations. You will also have the opportunity to exchange ideas with peers and industry experts and hear best practices from successful customer case studies.

To register or for more information, please contact Moe Nawaz at SQL Power Consulting:
416 221 4220 ext. 273

8:00am - Continental Breakfast & Registration
9:00am - Corporate Update
9:30am - Technology Demonstrations
10:15am - Networking Break
10:30am - Customer Success Stories
11:00am - Technology Demonstrations, continued
11:30am - Closing Remarks

Hilton Toronto
145 Richmond Street West
Toronto, ON M5H 2L2
(416) 869-3456

Thursday, January 20, 2011

Mobilizing Strategic Intelligence

Cost-effective Mobile BI technology is finally here!

If you're in the Toronto area, join us on Feb. 17 for a Free Breakfast Seminar to learn about cost-effective Mobile Business Intelligence. Register today at

Agenda includes:
- The Real Business Impact of Knowledge Discovery
- How to make the most of your BI Budget
- How to quickly address end-user BI demands for a fraction of the cost
- Timely Strategic Intelligence with Mobile Devices

Seminar includes a live demo of MicroStrategy Mobile BI and a Free Continental Breakfast.

Everyone is welcome, but space is limited so reserve your spot today!