 |
VOOZH | about |
|
VOOZH | about |
This guide walks you through everything you need to get started with the CData ODBC Driver for SQL Analysis Services. You'll learn how to install and license the driver, configure your first connection, and explore next steps for working with SQL Analysis Services data in your applications.
You should have received your license key via email from the CData Orders Team. The license key looks like this: XXXX-XXXX-XXXX-XXXX-XXXX
Your license would typically be activated during installation. However, there are cases where you may need to activate it manually. The steps below walk you through manual activation:
Can I use my license on multiple machines?
Yes, depending on your subscription tier. Check your order confirmation or contact your account representative for details. If you are unsure of who your account representative is, contact [email protected].
I lost my license key. How do I retrieve it?
Email [email protected] with your order number, and we'll resend your license key.
Can I transfer my license to a different machine?
Yes. When transferring the license to a different machine, you will need to submit a License Transfer Request on our site linked below:
https://www.cdata.com/lic/transfer/
After the License Transfer Request is submitted and successfully processed, an activation will be added to your Product Key and you will be able to activate the full license on the other machine. Once this process is finished, the license on the previous machine will be invalid.
For additional licensing questions, contact [email protected]. Viewing and upgrading your license can now be done through our self-service portal at portal.cdata.com.
Once your driver is installed and licensed, you're ready to configure a connection to SQL Analysis Services. The ODBC driver uses a DSN (Data Source Name) to store connection properties.
To connect, provide authentication and set the Url property to a valid SQL Server Analysis Services endpoint. You can connect to SQL Server Analysis Services instances hosted over HTTP with XMLA access. See the Microsoft documentation to configure HTTP access to SQL Server Analysis Services.
To secure connections and authenticate, set the corresponding connection properties, below. The data provider supports the major authentication schemes, including HTTP and Windows, as well as SSL/TLS.
Set AuthScheme to "Basic" or "Digest" and set User and Password. Specify other authentication values in CustomHeaders.
Set the Windows User and Password and set AuthScheme to "NTLM".
To authenticate with Kerberos, set AuthScheme to NEGOTIATE. To use Kerberos delegation, set AuthScheme to KERBEROSDELEGATION. If needed, provide the User, Password, and KerberosSPN. By default, the data provider attempts to communicate with the SPN at the specified Url.
By default, the data provider attempts to negotiate SSL/TLS by checking the server's certificate against the system's trusted certificate store. To specify another certificate, see the SSLServerCert property for the available formats.
You can then access any cube as a relational table: When you connect the data provider retrieves SSAS metadata and dynamically updates the table schemas. Instead of retrieving metadata every connection, you can set the CacheLocation property to automatically cache to a simple file-based store.
See the Getting Started section of the CData documentation, under Retrieving Analysis Services Data, to execute SQL-92 queries to the cubes.
Solution: Verify your credentials are current. For OAuth applications, you may need to authorize CData in your application's security settings. Contact [email protected] for authorization assistance.
Solution: Check firewall & proxy settings. Contact [email protected] for specific port requirements.
Solution: Verify database and schema names. Use the Data Model tab in the DSN configuration to browse available tables.
Solution: Verify the driver is correctly registered in odbcinst.ini. Contact [email protected] for further assistance.
For additional connection troubleshooting, contact [email protected] with your specific error message.
Now that you have installed, licensed, and configured the driver, here are some scenarios you can use to explore our ODBC Drivers:
If you need assistance at any point:
Driver={CData ODBC Driver for SQL Analysis Services};RequiredConnectionProperty1=Value1;RequiredConnectionProperty2=Value2;
Be prepared to securely upload the log file upon request when reaching out to [email protected] for troubleshooting analysis.
For questions not covered in this FAQ, contact [email protected].
Download a free trial of the SQL Analysis Services ODBC Driver to get started:
Download NowLearn more:
👁 SQL Server Analysis Services IconThe SQL Analysis Services ODBC Driver is a powerful tool that allows you to connect with live data from SQL Analysis Services, directly from any applications that support ODBC connectivity.
Access Analysis Services report data like you would a database, through a standard ODBC Driver interface. Supports Direct Query and MDX query capabilities.
