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.

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.
Enter data source type, and the connection string Click the blue arrow Next to move to the next step – build one or more external content types.

Connecting to Oracle →


Was this helpful?

Yes No
You indicated this topic was not helpful to you ...
Could you please leave a comment telling us why? Thank you!
Thanks for your feedback.

Post your comment on this topic.

Please do not use this for support questions.
For customer support, please contact us here.

Post Comment