Black Box ICOMP, User Manual

Page: 19 / 92

Copyright (c) 2009 - 2012 Black Box Corporation
724-746-5500 | blackbox.com 19
Building a Connection
2.3.4.1 Advanced Settings
The Advanced SQL Settings page allows the username , password and additional ODBC Connection String
settings to be specified.
Specifying how Dates and Numbers are written
To ensure the widest possible compatibility with media, by default, the iDE will write all numbers and dates in a
general, non-locale specific manner. However, in some instances, particularly when using the native iCOMPEL
features, it will be necessary to write data values using a specific locale representation.
The 'Write all data values using the following culture setting' controls this.
If this option is enabled, then a summary of the current setting will be shown the SQL page.
Specifying Additional Connection Parameters
The username and password fields will be used to connect to the database specified in the ODBC DSN setting.
2.3.5 XML Connector
The XML Connector is used to retrieve and process XML data.
To use this Connector, please select the XML option from the Data Source page, and visit the XML Location and
XML Schema pages to specify the configuration properties.
Note: This Connector may require an additional license to operate.