Login     Register

        Contact Us     Search

Frequently Asked Questions

Installation Requirements

» What are the system requirements for XLeratorDB?
» Does XLeratorDB work with SQL Server 2012, 2014, 2016, 2017, 2019, 2022?
» Who can install XLeratorDB?
» Does XLeratorDB require a server name?

Licensing

» How is XLeratorDB licensed?
» Can I transfer licenses between servers?
» What if I enter the server name incorrectly?
» What is the Extended Licensing Option (ELO)?
» How much does ELO cost?
» How many licenses do I need for a clustered server?
» Do development servers also require a license?
» Does XLeratorDB work with LocalDB?

Database Operation

» Will XLeratorDB change the data in my database?
» Who controls permissions and access to XLeratorDB?

Installation Issues

» Where do I get the database Server Name?
» Where can I find my License Key?
» How do I install XLeratorDB if my database server is behind a firewall?

Excel Functions

» How does XLeratorDB compare to Excel?
» Do I need Excel to run XLeratorDB?
» Are these Excel functions in some kind of a wrapper?

Documentation / Support

» Where can I find the documentation?
» What if I need more information?

  

 


 

Answers



Installation Requirements


What are the system requirements for XLeratorDB?

XLeratorDB runs on any machine running SQL Server 2005 or later (compatibility level 90 or higher) in either 32 or 64 bit configurations.

 

Does XLeratorDB work with SQL Server 2012? 2014? 2016? 2017? 2019? 2022?

Yes, XLeratorDB is routinely fully tested against all versions of SQL Server from 2012 to the latest release from Microsoft. The XLeratorDB products named as '2008' are intended for use on SQL Server 2008 and later.

 

Who can install XLeratorDB?

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.

 

Does XLeratorDB require a server name?

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.

 

Licensing


How is XLeratorDB licensed?

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.

 

Can I transfer licenses between servers?

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.

 

What if I enter the server name incorrectly?

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 support@westclintech.com or give us a call at 1 914 231 7137.

 

What is the Extended Licensing Option (ELO)?

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.

 

How much does ELO cost?

ELO is available in a 3-year and a 5-year option. ELO is 20% of the initial license fee per year.

 

How many licenses do I need for a clustered server?

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.

 

Do development servers also require a license?

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)

 

Does XLeratorDB work with LocalDB?

Yes, XLeratorDB will install and run in LocalDB instances from SQL Server Express 2012 and later.

 

Database Operation


Will XLeratorDB change the data in my database?

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.

 

Who controls permissions and access to XLertorDB?

All permissions and access are controlled by the DBA.

 

Installation Issues


Where do I get the database Server Name?

Open SQL Server Management Studio on the licensed server, type:

select SERVERPROPERTY('ComputerNamePhysicalNetBIOS')

And then hit F5.

 

Where can I find my License Key?

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.

 

How do I install XLeratorDB if my database server is behind a firewall?

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.

 

Excel Functions


How do XLeratorDB functions compare to EXCEL?

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.

 

Do I need EXCEL to run XLeratorDB?

No. The XLeratorDB functions are independent of Excel.

 

Are these EXCEL functions in some kind of a wrapper?

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


Where can I find the documentation?

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.

 

What if I need more information?

You can contact us at support@westclintech.com or go to the Contact Us page.

 

 

 

Copyright 2008-2024 Westclintech LLC         Privacy Policy        Terms of Service