Black Box ICOMP, User Manual

Page: 18 / 92

Copyright (c) 2009 - 2012 Black Box Corporation
724-746-5500 | blackbox.com 18
iCompel Data Engine - User Guide (V3.1.2)
The Name property is used to uniquely identify the calendar entry within the iCompel Data Engine user interface.
The URL is the location of the Google
®
Calendar feed. This can be determined as described in the Connecting to a
Google Calendar section.
Both properties are mandatory.
2.3.4 SQL Connector
The SQL Connector is used to retrieve and process data from a database, for example, Oracle
®
or Microsoft
®
SQL
Server
®
.
The iDE uses Microsoft
®
Windows Open Database Connectivity (ODBC) to access and query the database.
In order to use the SQL Connector the user must create one or more valid ODBC System Data Source Name (
System DSN ) entries on the local PC. Further information on this topic can be found in the Microsoft
®
Windows
®
help system.
Please select the SQL Connector option from the Data Source page, and visit the SQL Command page to specify
both the ODBC User DSN and SQL Query command to be executed. If user credentials are required to access the
database, then these can be specified on the Advanced Settings page.
Press the ODBC button to automatically start the Windows
®
ODBC Data Source Administrator application. Please
refer to this section if using the application on a 64bit operating system.
Note: This Connector may require an additional license to operate.