Connecting to ODBC

Open Data Base Connectivity (ODBC) is a driver based connectivity option which is supported by many external data sources. You must have the correct ODBC driver installed on your SharePoint server, both the machine where you have BCS Meta Man install as well as the SharePoint environment where you plan to use the BDC model in order for the ODBC option to work successfully.

*Information on ODBC drivers can be found on the following web site: http://en.wikipedia.org/wiki/ODBC#Drivers. There is also a ODBC walkthrough later in this documentation.

To connect to an ODBC external data source, complete the following steps:

1. Under Data Source, click ODBC and then in the data source type drop down list select one of the following:
   

• Oracle
• DB2
• MySQL
• PostgreSQL
• Sybase
• Microsoft SQL Server
• Microsoft Access
• FireBird
• Informix
• Progress
• Sage Mas 90
• SQL Anywhere
• Other Data Source

Type a left delimiter symbol and a right delimiter symbol. The default is a double quote " for both. In the connection string text box, type the connection string of how to connect to the ODBC data source.
Click the blue arrow to move to the next step – build one or more external content types.

*An example of how to create an BDC model for a MySQL database can be found in the Walkthroughs section.

Connecting to Oracle →

Copyright © 2024 Lightning Tools — Powered by