On the System tab, select CData Salesforce Source.Ĭlick the Add button to enter connection properties as key-value pairs.Sudo /Applications/iODBC/iODBC\ Administrator.app/Contents/MacOS/iODBC\ Administrator Open a terminal and enter the following command to start the iODBC Administrator with the necessary permissions:.However, modifying a system DSN requires elevated permissions. System DSNs can be accessed by all users, while user DSNs can only be accessed by a single user. The driver installation automatically creates a system DSN. Installing a CData ODBC Driver registers the driver with the iODBC driver manager, so the only remaining step is to use the iODBCĪdministrator to supply the necessary connection properties in a DSN. It is this tool that is used in the following procedure to create a DSN. The iODBC installation installs its own GUI, the iODBC Administrator. You can find the latest version of iODBC on the iODBC site. For a guide to creating and testing DSNs with unixODBC, see the "Getting Started" section in the help documentation. This makes the driver easy to use with these tools.Īnother driver manager, unixODBC, is widely supported by scripting languages like Python and Ruby. Products like Filemaker Pro and Microsoft Excel for Mac. The CData ODBC drivers are preconfigured for the iODBC driver manager, as are many other There are several options for user-friendly interfaces when it comes to configuring ODBC data sources on Mac OS X. Installing the CData ODBC Drivers on Mac OS X Of the driver as defined in the odbcinst.ini.ĭriver = CData ODBC Driver for Salesforce You will also need to set the Driver property to the name Refer to the "Getting Started" section in the help documentation for more information on the connection properties needed to connect to your data source. rpms, run the following command as root or with sudoĭefine the required connection properties in sections of an odbc.ini file. Tools or applications that support ODBC connectivity.įor Debian-based systems like Ubuntu, run the following command as root or with sudoįor systems that support. The driver installer registers the driver with unixODBC and creates a system DSN, which can be used later in any Once you have downloaded the file, you can install the driver from the terminal. IYou can downloading the driver in standard packages formats, the Debian. USER DATA SOURCES.: /home/myuser/.odbc.ini Below is an example of the output of this command:įILE DATA SOURCES.: /etc/ODBCDataSources User data sources can only be accessed by the user account whose home folder the odbc.ini is located in. The output of the command will display the locations of the configuration files for ODBC data sources and registered ODBCĭrivers. You can determine the location of the configuration files on your system by entering the following command into a The unixODBC driver manager reads information about drivers from an odbcinst.ini file and about data sources from an odbc.iniįile. unixODBC is a free and open source ODBCįor Debian-based systems like Ubuntu, you can install unixODBC with the APT package manager:įor systems based on Red Hat Linux, you can install unixODBC with yum or dnf: Installing the Driver Managerīefore installing the driver, you need to be sure that your system has a driver manager. See the "Getting Started" section in the help documentation for the libraries required by the driver. Using the CData ODBC Drivers on a Unix/Linux Machineīelow are the minimum supported versions for Red Hat-based and Debian-based systems: The ODBC Driver for Salesforce is used as an example. This article will walk you through the installation and configuration of any of our ODBC drivers on Mac OS X, Red Hat Linux, and Debian-based Linux environments like Ubuntu. Our ODBC drivers support unixODBC and iODBC, the most popular driver managers for Unix/Linux environments and Mac OS X, giving you unprecedented access to your Big Data, NoSQL, and SaaS sources from ODBC-capable tools and applications, no matter what operating system you use.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |