[Progress Communities] [Progress OpenEdge ABL] Forum Post: 2020.1 Snowflake ODBC Driver: Initial Preview Release

Status
Not open for further replies.
K

kbeutler

Guest
About Snowflake and the Snowflake ODBC driver Snowflake is a cloud data platform that focuses on data warehousing, analytics and data lakes. As Snowflake is gaining popularity, many of our customers and prospects are reporting a gap in the market for a stable and reliable solution for ODBC connectivity to Snowflake. The Progress DataDirect Snowflake ODBC driver will allow you to connect to your Snowflake data warehouse from any BI and/or ETL tool which supports standard ODBC connectivity. It can also be used with ODBC applications which are developed for standard RDBMS ODBC drivers without drastic changes. Release Highlights: The driver will support all the CRUD operations supported by Snowflake. The driver will be ODBC Standard 3.8 compliant and will utilize the SQL Engine capabilities of Snowflake for query execution. You can download the User's Guide and other relevant documentation for this driver along with the installer package from the URL below. The documentation will talk in detail about the minimum requirements, steps to configure the driver, and connection options supported by the driver. The readme file contains the release highlights and some of the functionality that is not part of this preview release. Features which are not part of the preview (but may be considered for GA) Authentication: ADFS (Active Directory Federation Services), OAUTH and multifactor Authentication. Transaction support Other OS platforms that are not Windows or Linux. Minimum requirements for Setup: Driver requires Java 1.8 or higher to work – Java 1.8 is installed during the installation process. Some of the basic connection option which are required to connect are: AccountName – Specifies the full name of your account and region where it is hosted. DatabaseName – Specifies the name of a Snowflake database. Schema – Specifies the default schema to use for a database once connected or an empty string. The specified schema should be an existing schema for which the default role has privileges. Alternatively USE SCHEMA command to change or update the Schema. Warehouse – Specifies the virtual warehouse to use once connected, or an empty string. The specified warehouse should be an existing warehouse for which the default role has privileges. UserID – Snowflake UserID Password – Password for the specified user connecting to Snowflake Sample Connection string "Driver=Datadirect 8.0 Snowflake Preview Driver; AccountName=progress_software.us-east1;LogonID= ;Password ;Schema= ;Warehouse= " Use Case: ODBC compliant applications needing connectivity to Snowflake to perform CRUD operations BI tools for data analysis. ETL tools performing operations (loading/reading) on data in Snowflake. Download Information: https://progress.thruinc.net/Publishing/Link.aspx?LinkID=2V3XNZ1RZ6CSJ Feedback: Are you able to use the driver out of the box for your Snowflake connectivity? If not, details about the challenges you faced/are facing. What OS platforms are a must have for you to use this driver effectively? What features do you feel are missing in the preview driver build and why do you believe they are important? What are your primary use cases and is this driver solving them? Is the driver's performance acceptable for your primary use case (loading records and fetching data)? If not, What is your use case, operation, data size, etc. What is the expectation?

Continue reading...
 
Status
Not open for further replies.
Top