![]() ![]() 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. Register ODBC drivers in odbcinst.ini.ĭefine ODBC data sources in sections in the odbc.ini file. To authenticate from these tools, you need to add the following connection property to the DSN to ensure that the OAuth flow can execute properly:Ĭonfigure DSNs in odbc.ini. Some tools, such as the iODBC Administrator 64-bit, require that you set the following connection property to complete the OAuth browser flow. For more information on the required connection properties, please refer to the documentation of each profile. The most common forms of authentication are supported, including HTTP basic, HTTP digest, NTLM, and OAuth. To establish a connection using a Profile, set the Profile property to the path of the API profile file, and ProfileSettings to a connection string containing the credentials to the data-source. API Profile files have the file exension ".apip" and can be download from the CData website. An API profile is a collection of schemas modeling data from an application or online service as tables, views or stored procedures. The driver can be used to connect to a variety of data sources, called Profiles, from within your application. The CData ODBC Driver for API can be used to connect to a variety of data sources from within your application. To create your own DSN, instead click Add on the User or System tab and then select the CData ODBC Driver for API option. Select the DSN and click the Configure button to set connection properties as name-value pairs. Sudo /Applications/iODBC/iODBC\ Administrator64.app/Contents/MacOS/iODBC\ Administrator64Īfter opening the iODBC Administrator 64-bit, you will see the CData API Source listed under the System tab. To do so, enter the following command into a terminal: To modify the system DSN installed by the driver or create a system DSN, open the iODBC Administrator 64-bit with elevated permissions. You can create user DSNs by opening the iODBC Administrator 64-bit from Launchpad. System data sources can be accessed by all users.Ĭonfiguring a DSN with the iODBC Administrator User data sources are restricted to a user account. Alternatively, you can edit the iODBC configuration files. The most recent version of the CData ODBC Driver for API is 64-bit only. Note that the ODBC Manager must match the bitness of the ODBC driver. To configure a DSN, you can use the iODBC Administrator 64-bit, the GUI installed with iODBC. The driver must be registered with the driver manager and DSNs are defined in the driver manager's configuration files. ![]() The driver manager loads the driver and passes function calls from the application to the driver. The driver installation registers the driver with iODBC and creates a system DSN, which you can use in any tools or applications that support ODBC connectivity. You can find the latest version of iODBC on the iODBC site. On macOS, the CData ODBC Driver for API is preconfigured for use with the iODBC driver manager, as are many other products like Filemaker Pro, Microsoft Excel, and Tableau. These refer to your name and your machine's password. You'll be prompted for a name and password. To activate a trial, omit the input.Ĭd "/Applications/CData ODBC Driver for API/bin" In a terminal, run the following commands to license the driver. The CData ODBC Driver for API driver requires macOS Sierra (10.12) or above. This section shows how to set up ODBC connectivity and configure DSNs on macOS. ![]()
0 Comments
Leave a Reply. |