XLeratorDB runs on any machine running SQL Server 2005 or later (compatibility level 90 or higher) in either 32 or 64 bit configurations.
Yes, XLeratorDB has been fully tested against SQL Server 2012, 2014 and 2016. The XLeratorDB products named as '2008' are intended for use on SQL Server 2008, 2012, 2014 and 2016.
Only the database administrator can install XLeratorDB on SQL Server and select the specific database(s) that the functions will run in. The installation program (.msi file) is downloaded to and physically resides on the licensed server. However, DBA admin privileges are required to actually run the SQL Server installation (in either automated or manual mode) and choose the database(s) for installation.
Yes. The server name is a critical component of XLeratorDB licensing and functionality. The name of the server where the target version of SQL Server resides is required at the time of download.
XLeratorDB is licensed per server with no restriction on the number of databases or the number of users on the licensed server. The name(s) of the licensed server(s) is (are) provided at the time of download.
If you purchase the extended licensing option (ELO), you may transfer licenses between servers during the extended licensing period, which is either 3 years or 5 years. Without ELO, you may only use the licensed software on the named server(s) provided prior to download.
If you have ELO, you can simply log in to your account and transfer the license to the correct server name. Without ELO you may still change the server name before downloading the software for the first time. Otherwise, contact us via e-mail at email@example.com or give us a call at 1 914 231 7137.
ELO allows you to transfer licenses between and among servers in your environment, provided that the number of servers on which the licensed software is installed is less than or equal to the number of licenses purchased.
ELO is available in a 3-year and a 5-year option. ELO is 20% of the initial license fee per year.
You need one package license for each active server with SQL Server 2008/R2 failover clustering. Servers configured as Passsive nodes in SQL Server 2008 and 2008R2 do not incur a charge. With HA (High Availability) AO (Always-On) in SQL Server 2012 and later a package license is required for all server nodes, active and passive.
Yes, XLeratorDB is licensed per server. There are products suitable specifically for development and test, including XLeratorDB Developer and DeveloperPLUS, as well as Subscription and SubscriptionPLUS. XLeratorDB Developer will only install and run in SQL Server Developer or Express editions. XLeratorDB Subscription is not restricted to Developer or Express and the license is valid for a one year period from date of purchase (not download)
Yes, XLeratorDB will install and run in LocalDB instances from SQL Server Express 2012 and later.
No. XLeratorDB installs with PERMISSION_SET=SAFE. SAFE mode, which is read-only, does not permit the creation of new data. Additionally, code executed by an assembly with SAFE permissions cannot access external system resources such as files, the network, the internet, environment variables, or the registry.
All permissions and access are controlled by the DBA.
Open SQL Server Management Studio on the licensed server, type:
And then hit F5.
Login to this web site with your user ID and go to the My Orders page. Please note that XLeratorDB software downloaded on or after October 1, 2011 no longer requires a license key for installation.
If the target database server cannot access the internet directly, the XLeratorDB installation file (.msi file) may be downloaded to an intermediate computer (e.g. a laptop) and the file later transferred to the target database server. Importantly, however, regardless of whether any intermediate computer is involved, the name of the target database server must be identified at the time of download.
XLeratorDB functions, in most cases, have been designed and extensively tested to replicate the results you would get using Excel. Some adaptations have been made to accommodate the requirements of the database environment. XLeratorDB does not include every function in Excel (because some are native in SQL Server), but it does include a wide range of functions that are not available in Excel; generally these are useful for the kind of large dataset analytics Excel cannot handle.
No. The XLeratorDB functions are independent of Excel.
No. We have written these functions from scratch and then run them millions of times against comparable functions in Excel to make sure that they worked. In some cases, they perform calculations that Excel does not. For example, in the ODDLPRICE and ODDLYIELD functions, XLeratorDB does not require that the settlement date be greater than the last interest date.
Documentation / Support
All the documentation is available on our web site http://westclintech.com or http://xleratordb.com. Click on the PRODUCTS menu (at the top of every page) and expand the product menu you are interested in to navigate to that product's documentation.
You can contact us at firstname.lastname@example.org or go to the Contact Us page.