Installing EDB-ODBC v12
The EDB ODBC Connector is distributed and installed with the EDB Postgres Advanced Server graphical or RPM installer.
Installing the Connector with an RPM Package
You can install the ODBC Connector using an RPM package on the following platforms:
On RHEL 7
Before installing the ODBC Connector, you must install the following prerequisite packages, and request credentials from EDB:
Install the epel-release
package:
Enable the optional, extras, and HA repositories:
You must also have credentials that allow access to the EDB repository. For information about requesting credentials, visit:
https://info.enterprisedb.com/rs/069-ALB-339/images/Repository%20Access%2004-09-2019.pdf
After receiving your repository credentials you can:
- Create the repository configuration file.
- Modify the file, providing your user name and password.
- Install
edb-odbc
.
Creating a Repository Configuration File
To create the repository configuration file, assume superuser privileges, and invoke the following command:
The repository configuration file is named edb.repo
. The file resides in /etc/yum.repos.d
.
Modifying the file, providing your user name and password
After creating the edb.repo
file, use your choice of editor to ensure that the value of the enabled
parameter is 1
, and replace the username
and password
placeholders in the baseurl
specification with the name and password of a registered EDB user.
Installing ODBC Connector
After saving your changes to the configuration file, use the following commands to install the ODBC Connector:
When you install an RPM package that is signed by a source that is not recognized by your system, yum may ask for your permission to import the key to your local server. If prompted, and you are satisfied that the packages come from a trustworthy source, enter y
, and press Return
to continue.
During the installation, yum may encounter a dependency that it cannot resolve. If it does, it will provide a list of the required dependencies that you must manually resolve.
On RHEL 8
Before installing the ODBC Connector, you must install the following prerequisite packages, and request credentials from EDB:
Install the epel-release
package:
Enable the codeready-builder-for-rhel-8-\*-rpms
repository:
You must also have credentials that allow access to the EDB repository. For information about requesting credentials, visit:
https://info.enterprisedb.com/rs/069-ALB-339/images/Repository%20Access%2004-09-2019.pdf
After receiving your repository credentials you can:
- Create the repository configuration file.
- Modify the file, providing your user name and password.
- Install
edb-odbc
.
Creating a Repository Configuration File
To create the repository configuration file, assume superuser privileges, and invoke the following command:
The repository configuration file is named edb.repo
. The file resides in /etc/yum.repos.d
.
Modifying the file, providing your user name and password
After creating the edb.repo
file, use your choice of editor to ensure that the value of the enabled
parameter is 1
, and replace the username
and password
placeholders in the baseurl
specification with the name and password of a registered EDB user.
Installing ODBC Connector
After saving your changes to the configuration file, use the below command to install the ODBC Connector:
When you install an RPM package that is signed by a source that is not recognized by your system, yum may ask for your permission to import the key to your local server. If prompted, and you are satisfied that the packages come from a trustworthy source, enter y
, and press Return
to continue.
During the installation, yum may encounter a dependency that it cannot resolve. If it does, it will provide a list of the required dependencies that you must manually resolve.
On CentOS 7
Before installing the ODBC Connector, you must install the following prerequisite packages, and request credentials from EDB:
Install the epel-release
package:
Note
You may need to enable the [extras]
repository definition in the CentOS-Base.repo
file (located in /etc/yum.repos.d
).
You must also have credentials that allow access to the EDB repository. For information about requesting credentials, visit:
https://info.enterprisedb.com/rs/069-ALB-339/images/Repository%20Access%2004-09-2019.pdf
After receiving your repository credentials you can:
- Create the repository configuration file.
- Modify the file, providing your user name and password.
- Install
edb-odbc
.
Creating a Repository Configuration File
To create the repository configuration file, assume superuser privileges, and invoke the following command:
The repository configuration file is named edb.repo
. The file resides in /etc/yum.repos.d
.
Modifying the file, providing your user name and password
After creating the edb.repo
file, use your choice of editor to ensure that the value of the enabled
parameter is 1
, and replace the username
and password
placeholders in the baseurl
specification with the name and password of a registered EDB user.
Installing ODBC Connector
After saving your changes to the configuration file, use the following command to install the ODBC Connector:
When you install an RPM package that is signed by a source that is not recognized by your system, yum may ask for your permission to import the key to your local server. If prompted, and you are satisfied that the packages come from a trustworthy source, enter y
, and press Return
to continue.
During the installation, yum may encounter a dependency that it cannot resolve. If it does, it will provide a list of the required dependencies that you must manually resolve.
On Rocky Linux or Alma Linux 8
Before installing the ODBC Connector, you must install the following prerequisite packages, and request credentials from EDB:
Install the epel-release
package:
Enable the PowerTools
repository:
You must also have credentials that allow access to the EDB repository. For information about requesting credentials, visit:
https://info.enterprisedb.com/rs/069-ALB-339/images/Repository%20Access%2004-09-2019.pdf
After receiving your repository credentials you can:
- Create the repository configuration file.
- Modify the file, providing your user name and password.
- Install
edb-odbc
.
Creating a Repository Configuration File
To create the repository configuration file, assume superuser privileges, and invoke the following command:
The repository configuration file is named edb.repo
. The file resides in /etc/yum.repos.d
.
Modifying the file, providing your user name and password
After creating the edb.repo
file, use your choice of editor to ensure that the value of the enabled
parameter is 1
, and replace the username
and password
placeholders in the baseurl
specification with the name and password of a registered EDB user.
Installing ODBC Connector
After saving your changes to the configuration file, use the following command to install the ODBC Connector:
When you install an RPM package that is signed by a source that is not recognized by your system, yum may ask for your permission to import the key to your local server. If prompted, and you are satisfied that the packages come from a trustworthy source, enter y
, and press Return
to continue.
During the installation, yum may encounter a dependency that it cannot resolve. If it does, it will provide a list of the required dependencies that you must manually resolve.
Updating an RPM Installation
If you have an existing EDB ODBC connector RPM installation, you can use yum or dnf to upgrade your repository configuration file and update to a more recent product version. To update the edb.repo
file, assume superuser privileges and enter:
On RHEL or CentOS 7:
yum upgrade edb-repo
On RHEL or Rocky Linux or AlmaLinux 8:
dnf upgrade edb-repo
yum or dnf will update the edb.repo
file to enable access to the current EDB repository, configured to connect with the credentials specified in your edb.repo
file. Then, you can use yum or dnf to upgrade any installed packages:
On RHEL or CentOS 7:
yum upgrade edb-odbc
yum upgrade edb-odbc-devel
On RHEL or Rocky Linux or AlmaLinux 8:
dnf upgrade edb-odbc
dnf upgrade edb-odbc-devel
Installing the Connector on an SLES 12 Host
You can use the zypper package manager to install the connector on an SLES 12 host. zypper will attempt to satisfy package dependencies as it installs a package, but requires access to specific repositories that are not hosted at EDB. Before installing the connector, use the following commands to add EDB repository configuration files to your SLES host:
zypper addrepo https://zypp.enterprisedb.com/suse/edb-sles.repo
After creating the repository configuration files, use the zypper refresh
command to refresh the metadata on your SLES host to include the EDB repositories.
When prompted for a User Name
and Password
, provide your connection credentials for the EDB repository. To request credentials for the repository, visit the EDB website.
Before installing EDB Postgres Advanced Server or supporting components, you must also add SUSEConnect and the SUSE Package Hub extension to the SLES host, and register the host with SUSE, allowing access to SUSE repositories. Use the commands:
zypper install SUSEConnect
SUSEConnect -r 'REGISTRATION_CODE' -e 'EMAIL'
SUSEConnect -p PackageHub/12.4/x86_64
SUSEConnect -p sle-sdk/12.4/x86_64
For detailed information about registering a SUSE host, visit the SUSE website.
Then, you can use the zypper utility to install the connector:
zypper install edb-odbc
zypper install edb-odbc-devel
Installing the Connector on a Debian or Ubuntu Host
To install a DEB package on a Debian or Ubuntu host, you must have credentials that allow access to the EDB repository. To request credentials for the repository, visit the EDB website.
The following steps will walk you through on using the EDB apt repository to install a DEB package. When using the commands, replace the username
and password
with the credentials provided by EDB.
Assume superuser privileges:
Configure the EDB repository:
Set up the EDB repository:
Substitute your EDB credentials for the
username
andpassword
in the following command:
Add support to your system for secure APT repositories:
Add the EDB signing key:
Update the repository metadata:
Install DEB package:
Using the Graphical Installer to Install the Connector
You can use the EDB Connectors Installation wizard to add the ODBC connector to your system; the wizard is available at the EDB website.
Download the installer, and then, right-click on the installer icon, and select Run As Administrator
from the context menu.
When the Language Selection
popup opens, select an installation language and click OK
to continue to the Setup
window (shown in Figure below).
The ODBC Connectors Installation wizard.
Click Next
to continue.
The Installation dialog
Use the Installation Directory
dialog to specify the directory in which the connector will be installed, and click Next
to continue.
The Ready to Install dialog.
Click Next
on the Ready to Install
dialog to start the installation; popup dialogs confirm the progress of the installation wizard.
The installation is complete.
When the wizard informs you that it has completed the setup, click the Finish
button to exit the dialog.
You can also use StackBuilder Plus to add or update the connector on an existing Advanced Server installation; to open StackBuilder Plus, select StackBuilder Plus
from the Windows Apps
menu.
Starting StackBuilder Plus
When StackBuilder Plus opens, follow the onscreen instructions. Select the EnterpriseDB ODBC Connector
option from the Database Drivers
node of the tree control.
Selecting the Connectors installer.
Follow the directions of the onscreen wizard to add or update an installation of the EDB Connectors.