![]() After you have configured odbc.ini, run the following command. Mac OS validates our drivers separately so you need to copy the license file to the appropriate path as well. OAuthCallbackURL = If you wish to authenticate using OAuth, you will need to add an additional connection property to ensure that the OAuth flow can execute properly: Other = CheckPromptMode=False Place your connection properties at the beginning of odbc.ini:ĭriver = CData ODBC Driver for Microsoft OneDrive In addition to the connection properties required to connect to Microsoft OneDrive, the Driver property specifies either a driver definition in the odbcinst.ini file or the path to the driver library. This will limit the number of rows returned, which is especially helpful for improving performance when designing reports and visualizations. When you configure the DSN, you may also want to set the Max Rows connection property. See the OAuth section of the Help documentation for an authentication guide. To authenticate using OAuth, you will need to create an app to obtain the OAuthClientId, OAuthClientSecret, and CallbackURL connection properties. OneDrive uses the OAuth authentication standard. Modifying iODBC's system-wide settings requires elevated permissions to do so, you can use following to open a text editor from the terminal: You can find the correct odbc.ini in the following paths: System data sources can be accessed by all users. User data sources can only be accessed by the user account whose home folder the odbc.ini is located in. ![]() You can define ODBC data sources in sections in the odbc.ini file. To activate a trial license, omit the key input.Ĭd "/Applications/CData ODBC Driver for Microsoft OneDrive/bin" In a terminal run the following commands to license the driver. This makes the driver easy to use with these tools. The CData ODBC Driver for Microsoft OneDrive is preconfigured for the iODBC driver manager, as are many other products like Microsoft Excel. Installing the CData ODBC Drivers on Mac OS X This article walks through creating a DSN for Microsoft OneDrive data in iODBC and accessing Microsoft OneDrive data in Microsoft Excel, all on a machine running Mac OS X. Set the environment variables LC_CTYPE and LC_NUMERIC or the parameters CONNECTIONLCCTYPE and CONNECTIONLCNUMERIC in the odbc.ini file to a locale that can display the characters.Īpplications using the DataDirect driver manager need UTF-8 locales.Microsoft Excel features calculations, graphing tools, pivot tables, and a macro programming language that allows users to work with data in many of the ways that suit their needs, whether on a Windows machine or a Macintosh machine. Incompatible locale defined in the odbc.ini file. Wrong locale defined in the LC_ALL variable.ĭefine a locale in the LC_ALL variable that can display the characters properly. Specify the correct odbc.ini file through the environment variable ODBCINI. The unixODBC driver manager is using the wrong odbc.ini file. Specify the correct version of the unixODBC through Wrong version of the unixODBC is used because of multiple installation instances. Install a full Perl system and try again. The operating system may not have the full Perl installation. Change into the install directory and then run config_odbc as shown below: To configure the driver, run the config_odbc program to generate the odbc.ini file. For more details, refer to the license file which is located in the folder where the driver was installed. The license allows you to bundle the driver with third-party software, for example when creating plugins for a BI tool. For Linux/FreeBSD: tar -xzf EXASOL_įor configuration information, see the readme.txt file included in the driver package.Įach driver package includes the latest version of the license for the driver.Run the following commands to extract the package in a directory:.Go to the Exasol Downloads portal and download the ODBC driver for your Exasol version and operating system.On some operating systems, OpenSSL must be installed separately. The Exasol ODBC driver needs at least OpenSSL 1.1 to run. The Exasol ODBC drivers for Linux and FreeBSD are tested on the following systems:
0 Comments
Leave a Reply. |