Open Database Connectivity, or ODBC, is an open standard method of accessing data from a database. BMC will provide read-only ODBC access to your BMC Helix databases upon request. To request access, you must provide the required information detailed below, and submit a request through your support portal. If you are using the i.onbmc.com support portal, use the Request Something Else option if requesting access prior to go-live, or use the Request a Change option if you are requesting access after you are live in production. For Support Central users, submit a case requesting this access.
ODBC access requires implementation of the BMC Helix Client Gateway as a prerequisite. If you do not already have the gateway configured, you must submit a separate request via your support portal.
For any ODBC access request, the following table details the information to be provided by each party:
|If you are pulling data from an on premises database, you need you provide to BMC:|
|Use case(s)||BMC needs to understand your use case(s) for requiring direct database access.This will help us determine if an alternate process is more suitable to what you're trying to accomplish.|
|Environments||You need to indicate which environment(s) require ODBC connectivity, for example, development and production, or production only.|
|ODBC login ID||If a have specific requirements for the service account's login ID used to access the database, let us know your preferred name. If you have no preference, BMC will provide one for you.|
Server IP address
|Provide the IP address of the on premises server that will be used to connect to the BMC Helix database.|
|Contact names and emails||Include the name and emails of any other contacts who will be involved in the implementation or testing of the ODBC connectivity. These contact(s) will be included on all communication from BMC, including notification of the login ID and password credentials.|
|BMC Client Gateway configuration file||You need to provide a copy of your |
|If you are pulling data from a BMC-hosted database, BMC will provide to you:|
|Database name||BMC will provide the names for the requested database servers.|
|ODBC login ID and password||BMC will either use the name you requested or provide a login ID using its standard naming convention, along with the password for the ODBC account. There will be a unique pair for each environment.|
|Database IP address||BMC will provide you with the database server's IP address.|
|ODBC port number|
BMC will provide to you ODBC standard port numbers for each environment.
Before access is granted, BMC requires the customer to review and acknowledge the following risks associated with an ODBC account:
The data you will be accessing needs an interpreter (driver) which understands the format of the stored data, and a connection manager that determines how the connection needs to be made. This information is stored in a data source. The purpose of the data source is to gather the technical information needed to access the data – the driver name, network address, network software, and so on – into a single place and make the data access transparent to the user. To configure this data source, see How To Set up a Microsoft SQL Server ODBC Data Source. You will need some of the information detailed above prior to configuration.
Once you have your ODBC data source configured, BMC will work with you to validate that the connectivity between the two servers is working as designed. The design and implementation of all data queries is the responsibility of the customer.