Check out the latest blog from our tutorial rumble and learn how to Configure Arcplan with Apache Spark SQL in 12 easy steps!
We recently had a tutorial rumble to discover what problems you, our customers, were having or how we could make your life easier. Here is the latest solution we've been working on.
Arcplan is a Business Intelligence software for budgeting, planning, analytics and collaborative Business Intelligence. It supports more than 20 data sources and also provides a generic ODBC interface to connect to any backend that has an ODBC driver.
This tutorial shows a 32-bit Arcplan Application Designer 8.6 working with the 32-bit Progress DataDirect for ODBC for Apache Spark SQL driver. The same steps are applicable to other ODBC drivers available from Progress.
In this example, since a System DSN named “SparkSQL” was created in step three, with the Data Sources option selected, select the “SparkSQL” ODBC DSN from the drop down list.
NOTE: If you have AutheticationMethod=-1 (No Authentication) or 1 (KERBEROS) set in the DataDirect Apache Spark SQL data source, you will not be prompted for login information and the driver will directly connect to the Apache Spark SQL database using the specified authentication mechanism.
If your database has a large number of objects, it may be difficult to view the tables/views you need to access using the application. Setting the Use Current Schema for Catalog Functions option improves performance by returning only database objects owned by the current user when executing catalog functions. Refer again to the User's Guide and Reference, under “Reference” > “Connection Option Descriptions for Apache Spark SQL” > “Use Current Schema for Catalog Functions,” for the connection option details and valid values.
To try this out yourself, check out our free trial, and don't forget to refer to the Quick Start Guide for other connection option settings to improve performance.
Spark SQL Free Trial
All Our Quick Start Guides
Rashmi Gupta is part of the Progress Technical Support team and currently holds the position of Senior Technical Support Engineer. Her main support portfolio includes DataDirect and Corticon. She is a key support team member with knowledge of ODBC, JDBC and ADO.NET amongst the technologies Progress offers.
Copyright © 2019 Progress Software Corporation and/or its subsidiaries or affiliates.
All Rights Reserved.
Progress, Telerik, and certain product names used herein are trademarks or registered trademarks of Progress Software Corporation and/or one of its subsidiaries or affiliates in the U.S. and/or other countries. See Trademarks for appropriate markings.