We may earn an affiliate commission when you visit our partners.
Emilio Melo
Since its inception, SharePoint has always been about empowering the end users to do more, without depending on longer development cycles. This course will teach you how to work with data sources as SharePoint external lists, by leveraging BCS.
Read more
Since its inception, SharePoint has always been about empowering the end users to do more, without depending on longer development cycles. This course will teach you how to work with data sources as SharePoint external lists, by leveraging BCS.
Read more
Since its inception, SharePoint has always been about empowering the end users to do more, without depending on longer development cycles. This course will teach you how to work with data sources as SharePoint external lists, by leveraging BCS.
Quite often, end users just need quick access to data sources, without having to endure the longer development cycles of a full front-end system. In this course, Planning and Configuring Business Connectivity Services in SharePoint 2019, you’ll learn to configure BCS to access such data sources on SharePoint. First, you’ll explore what BCS is and how to configure that on SharePoint. Next, you’ll discover how to use SharePoint Designer to create external lists. Finally, you’ll learn how to access these lists from SharePoint. When you’re finished with this course, you’ll have the skills and knowledge of SharePoint Business Connectivity Services needed to access external data sources on SharePoint 2019.
This course is no longer available. Find something similar by browsing:
Business Connectivity Services
SharePoint 2019
External Lists
Data Access
SharePoint Designer
Register for this course and see more details by visiting:
OpenCourser.com/course/745xkt/planning
What's inside
Syllabus
Course Overview
Business Connectivity Services Overview
Configuring BDC Models
Working with BCS on SharePoint
Read more
Syllabus
Course Overview
Business Connectivity Services Overview
Configuring BDC Models
Working with BCS on SharePoint
Read more
Traffic lights
Traffic lights
Read about what's good
what should give you pause and
possible dealbreakers
Suitable for individuals seeking to enhance their working knowledge of data manipulation within SharePoint
Suitable for those who want to integrate external data sources into SharePoint without the need for extensive coding capabilities
Facilitates collaboration between non-technical end users and data sources within SharePoint
Save this course
Create your own learning path.
Save this course to your list so you can find it easily later.
Save
Save
Reviews summary
Sharepoint 2019 bcs configuration guide
According to students, this course provides a solid foundation in Business Connectivity Services (BCS) for SharePoint 2019. Learners particularly appreciate the practical application of concepts, enabling them to integrate external data sources efficiently without extensive development cycles. The course is noted for its clear explanations of complex topics like BDC Models and offers a valuable balance between theoretical understanding and hands-on configuration. While highly beneficial for those managing SharePoint 2019 environments, some suggest a basic understanding of SharePoint is beneficial to fully grasp the material.
Highly relevant for SharePoint 2019 environments.
"This course is perfect if you are working with SharePoint 2019 specifically."
"As someone managing an on-premises SharePoint 2019 deployment, this was exactly what I needed."
"The content is tailored for SharePoint 2019, which is a pro for current users but might limit future applicability."
Good mix of conceptual understanding and practical application.
"I found a great balance between understanding the theory and actual practical configuration in this course."
"I liked that the demos were not just conceptual but showed how to actually implement things."
"The hands-on aspects of configuring BDC models were particularly helpful for my learning."
Explains complex Business Connectivity Services clearly.
"The instructor did a great job explaining the often confusing aspects of BCS."
"I appreciated the breakdown of BDC Models; it made the whole process much clearer."
"Before this course, BCS felt overwhelming, but now I grasp the key concepts easily."
Provides immediate, applicable skills for data integration.
"I found the course directly applicable to my work in integrating external data with SharePoint."
"This course taught me practical ways to configure BCS that I could use right away."
"My understanding of connecting external systems to SharePoint 2019 greatly improved after this."
May require existing SharePoint familiarity for best experience.
"I felt a bit lost sometimes, as it seemed to assume a baseline knowledge of SharePoint administration."
"This course is not for absolute beginners to SharePoint; some prior experience is definitely helpful."
"Recommend brushing up on general SharePoint concepts before diving into this if you're new."
Activities
Be better prepared
before
your course. Deepen your understanding
during
and
after
it. Supplement your coursework and achieve mastery of the topics covered
in Planning and Configuring Business Connectivity Services in SharePoint 2019 with these
activities:
Create a Study Binder
Show steps
Organizing your notes and materials reinforces learning and makes it easier to access what you need when you need it.
Show steps
-
Gather your notes, assignments, and study materials
-
Organize them into a logical structure, such as topics and subtopics
-
Consider using color-coding or tabs for quick referencing
Review BCS in Advance
Show steps
Reviewing BCS will give you necessary background and set you up for success.
Browse courses on
Business Connectivity Services
Show steps
-
Review overview of BCS
-
Review how to use BCS on SharePoint
-
Review how to use SharePoint Designer to create external lists
Explore Microsoft's documentation on Business Connectivity Services
Show steps
Enhance your knowledge by referring to official resources, deepening your understanding of BCS concepts and their implementation.
Show steps
-
Visit the Microsoft documentation website.
-
Locate the section on Business Connectivity Services.
-
Read through the tutorials and articles related to BCS.
-
Take notes on key concepts and best practices.
12 other activities
Expand to see all activities and additional details
Show all 15 activities
Create External Lists from Different Data Sources
Show steps
Enhance your skills in accessing and leveraging data from various sources by creating multiple external lists.
Show steps
-
Connect to a database using BCS.
-
Create an external list based on a SQL table.
-
Connect to a web service using BCS.
-
Create an external list based on web service data.
Practice creating external lists using SharePoint Designer
Show steps
Reinforce the concepts of creating and working with external lists to improve your understanding of data access in SharePoint.
Browse courses on
SharePoint Designer
Show steps
-
Gather the required data source information, such as the URL and authentication method.
-
Create a new external content type in SharePoint Designer.
-
Configure the external content type to connect to the data source.
-
Create a new external list based on the external content type.
-
Test the external list to ensure that data is being retrieved successfully.
Review OData Protocol and BCS Documentation
Show steps
Gain a deeper understanding of the underlying technologies used in BCS, improving your ability to configure and troubleshoot issues.
Browse courses on
OData
Show steps
-
Read the OData Protocol documentation.
-
Review the BCS documentation.
-
Complete tutorial on configuring BCS in SharePoint.
Follow SharePoint BCS Tutorials
Show steps
Following tutorials provides hands-on practice, allowing you to apply you knowledge and understand concepts better.
Browse courses on
Business Connectivity Services
Show steps
-
Find high-quality tutorials on SharePoint BCS
-
Follow each tutorial step-by-step
-
Experiment with different features and options
-
Troubleshoot any issues you encounter
Join a study group or discussion forum for SharePoint experts
Show steps
Connect with fellow SharePoint enthusiasts to exchange ideas, troubleshoot issues, and expand your knowledge of BCS.
Browse courses on
Community Engagement
Show steps
-
Identify relevant study groups or forums online.
-
Join the group or forum and introduce yourself.
-
Participate in discussions and ask questions related to BCS.
-
Share your own insights and experiences with the group.
BCS Coding Practice
Show steps
Practice drills provide opportunities to test and solidify your understanding of BCS configuration and implementation.
Browse courses on
Business Connectivity Services
Show steps
-
Find coding drills and practice questions
-
Attempt to solve the problems on your own
-
Review solutions and explanations
-
Repeat steps 2 and 3 until you are confident
Develop a sample application that utilizes BCS to access external data
Show steps
Apply your knowledge by building a practical application, demonstrating your ability to configure and use BCS effectively.
Browse courses on
Project-Based Learning
Show steps
-
Define the scope and objectives of your project.
-
Identify the external data source you want to access.
-
Configure BCS in SharePoint to connect to the data source.
-
Create an application that interacts with the external data through BCS.
-
Test and refine your application to ensure functionality.
BCS Implementation Project
Show steps
A project allows you to put your knowledge into practice, building a concrete deliverable that showcases your skills.
Browse courses on
Business Connectivity Services
Show steps
-
Choose a suitable project idea
-
Plan and design your implementation
-
Configure BCS and implement your solution
-
Document and present your project
Develop a Custom Web Part to Display External Data
Show steps
Apply your knowledge by creating a practical solution that showcases your ability to integrate external data into SharePoint.
Show steps
-
Create a custom web part project in Visual Studio.
-
Use the SharePoint Client Object Model to retrieve data from an external list.
-
Render the data in an HTML template.
-
Deploy and test the custom web part.
Build a SharePoint Intranet with BCS Integration
Show steps
Reinforce your learning by applying your skills to a comprehensive project that mimics real-world scenarios.
Browse courses on
Project-Based Learning
Show steps
-
Plan the intranet structure and identify external data sources.
-
Configure BCS to connect to the data sources.
-
Create external lists and views to display the data.
-
Develop custom web parts to enhance functionality.
-
Deploy and test the intranet.
Volunteer as a BCS Mentor
Show steps
Mentoring others strengthens your own understanding and helps you identify areas where your knowledge is solid or needs improvement.
Show steps
-
Identify opportunities to mentor other students or colleagues
-
Share your knowledge and experience
-
Provide constructive feedback and support
Attend a BCS Community Event
Show steps
Networking events facilitate connections with industry professionals, providing insights and opportunities to explore.
Browse courses on
Business Connectivity Services
Show steps
-
Find and register for relevant events
-
Attend sessions and presentations
-
Network with other attendees
Create a Study Binder
Show steps
Organizing your notes and materials reinforces learning and makes it easier to access what you need when you need it.
Show steps
Show steps
Show steps
- Gather your notes, assignments, and study materials
- Organize them into a logical structure, such as topics and subtopics
- Consider using color-coding or tabs for quick referencing
Review BCS in Advance
Show steps
Reviewing BCS will give you necessary background and set you up for success.
Browse courses on
Business Connectivity Services
Show steps
Show steps
Show steps
- Review overview of BCS
- Review how to use BCS on SharePoint
- Review how to use SharePoint Designer to create external lists
Explore Microsoft's documentation on Business Connectivity Services
Show steps
Enhance your knowledge by referring to official resources, deepening your understanding of BCS concepts and their implementation.
Show steps
Show steps
Show steps
- Visit the Microsoft documentation website.
- Locate the section on Business Connectivity Services.
- Read through the tutorials and articles related to BCS.
- Take notes on key concepts and best practices.
12 other activities
Expand to see all activities and additional details
Show all 15 activities
Create External Lists from Different Data Sources
Show steps
Enhance your skills in accessing and leveraging data from various sources by creating multiple external lists.
Show steps
Show steps
Show steps
- Connect to a database using BCS.
- Create an external list based on a SQL table.
- Connect to a web service using BCS.
- Create an external list based on web service data.
Practice creating external lists using SharePoint Designer
Show steps
Reinforce the concepts of creating and working with external lists to improve your understanding of data access in SharePoint.
Browse courses on
SharePoint Designer
Show steps
Show steps
Show steps
- Gather the required data source information, such as the URL and authentication method.
- Create a new external content type in SharePoint Designer.
- Configure the external content type to connect to the data source.
- Create a new external list based on the external content type.
- Test the external list to ensure that data is being retrieved successfully.
Review OData Protocol and BCS Documentation
Show steps
Gain a deeper understanding of the underlying technologies used in BCS, improving your ability to configure and troubleshoot issues.
Browse courses on
OData
Show steps
Show steps
Show steps
- Read the OData Protocol documentation.
- Review the BCS documentation.
- Complete tutorial on configuring BCS in SharePoint.
Follow SharePoint BCS Tutorials
Show steps
Following tutorials provides hands-on practice, allowing you to apply you knowledge and understand concepts better.
Browse courses on
Business Connectivity Services
Show steps
Show steps
Show steps
- Find high-quality tutorials on SharePoint BCS
- Follow each tutorial step-by-step
- Experiment with different features and options
- Troubleshoot any issues you encounter
Join a study group or discussion forum for SharePoint experts
Show steps
Connect with fellow SharePoint enthusiasts to exchange ideas, troubleshoot issues, and expand your knowledge of BCS.
Browse courses on
Community Engagement
Show steps
Show steps
Show steps
- Identify relevant study groups or forums online.
- Join the group or forum and introduce yourself.
- Participate in discussions and ask questions related to BCS.
- Share your own insights and experiences with the group.
BCS Coding Practice
Show steps
Practice drills provide opportunities to test and solidify your understanding of BCS configuration and implementation.
Browse courses on
Business Connectivity Services
Show steps
Show steps
Show steps
- Find coding drills and practice questions
- Attempt to solve the problems on your own
- Review solutions and explanations
- Repeat steps 2 and 3 until you are confident
Develop a sample application that utilizes BCS to access external data
Show steps
Apply your knowledge by building a practical application, demonstrating your ability to configure and use BCS effectively.
Browse courses on
Project-Based Learning
Show steps
Show steps
Show steps
- Define the scope and objectives of your project.
- Identify the external data source you want to access.
- Configure BCS in SharePoint to connect to the data source.
- Create an application that interacts with the external data through BCS.
- Test and refine your application to ensure functionality.
BCS Implementation Project
Show steps
A project allows you to put your knowledge into practice, building a concrete deliverable that showcases your skills.
Browse courses on
Business Connectivity Services
Show steps
Show steps
Show steps
- Choose a suitable project idea
- Plan and design your implementation
- Configure BCS and implement your solution
- Document and present your project
Develop a Custom Web Part to Display External Data
Show steps
Apply your knowledge by creating a practical solution that showcases your ability to integrate external data into SharePoint.
Show steps
Show steps
Show steps
- Create a custom web part project in Visual Studio.
- Use the SharePoint Client Object Model to retrieve data from an external list.
- Render the data in an HTML template.
- Deploy and test the custom web part.
Build a SharePoint Intranet with BCS Integration
Show steps
Reinforce your learning by applying your skills to a comprehensive project that mimics real-world scenarios.
Browse courses on
Project-Based Learning
Show steps
Show steps
Show steps
- Plan the intranet structure and identify external data sources.
- Configure BCS to connect to the data sources.
- Create external lists and views to display the data.
- Develop custom web parts to enhance functionality.
- Deploy and test the intranet.
Volunteer as a BCS Mentor
Show steps
Mentoring others strengthens your own understanding and helps you identify areas where your knowledge is solid or needs improvement.
Show steps
Show steps
Show steps
- Identify opportunities to mentor other students or colleagues
- Share your knowledge and experience
- Provide constructive feedback and support
Attend a BCS Community Event
Show steps
Networking events facilitate connections with industry professionals, providing insights and opportunities to explore.
Browse courses on
Business Connectivity Services
Show steps
Show steps
Show steps
- Find and register for relevant events
- Attend sessions and presentations
- Network with other attendees
Career center
Learners who complete Planning and Configuring Business Connectivity Services in SharePoint 2019 will develop knowledge and skills
that may be useful to these careers:
SharePoint Administrator
SharePoint Administrator
A SharePoint Administrator manages and maintains SharePoint, a collaborative software platform. SharePoint Administrators typically have a bachelor's degree in Computer Science, Information Technology, or a related field. Courses like Planning and Configuring Business Connectivity Services in SharePoint 2019 can help develop the skills needed in managing and configuring SharePoint.
Data Integration Specialist
Data Integration Specialist
A Data Integration Specialist designs, develops, and maintains systems that integrate data from multiple sources. They typically have a bachelor's or master's in Computer Science, Information Technology, or a related field. Courses like Planning and Configuring Business Connectivity Services in SharePoint 2019 may be useful for learning how to work with data integration tools and technologies for enterprise systems.
Data Warehouse Engineer
Data Warehouse Engineer
A Data Warehouse Engineer designs, builds, and maintains data warehouses. They typically have a bachelor's or master's in Computer Science, Information Technology, or a related field. Courses like Planning and Configuring Business Connectivity Services in SharePoint 2019 may be useful for learning how to work with data modeling and data integration for enterprise systems.
Data Analyst
Data Analyst
A Data Analyst works with data to help businesses understand and improve. Data Analysts typically have an advanced degree in fields such as Statistics, Computer Science, or Business Administration. Courses like Planning and Configuring Business Connectivity Services in SharePoint 2019 can help Data Analysts connect to and manage data sources, which can aid them in their work.
Systems Analyst
Systems Analyst
A Systems Analyst gathers and analyzes business needs to design and implement software solutions. To enter this role, one typically needs a bachelor's degree in Computer Science, Systems Analysis, or a related field. Courses like this one on Planning and Configuring Business Connectivity Services in SharePoint 2019 can help students to develop a foundation in business analysis and data modeling.
Software Developer
Software Developer
A Software Developer designs, develops, and maintains software applications. Software Developers typically have a bachelor's or master's degree in Computer Science or a related field. Courses like Planning and Configuring Business Connectivity Services in SharePoint 2019 may be useful in understanding how to work with enterprise technologies.
Business Analyst
Business Analyst
A Business Analyst clarifies business needs and translates them into technical requirements. To become a Business Analyst, one may need to get educated in Business Administration, Systems Analysis, or a related field. Getting a Business Requirements Document online certificate may also be helpful. Courses like this one on Planning and Configuring Business Connectivity Services in SharePoint 2019 may also help one build a foundation in defining business needs and working with data sources as SharePoint external lists.
IT Consultant
IT Consultant
An IT Consultant provides advice and guidance to businesses on how to use information technology to meet their business goals. IT Consultants typically have a bachelor's or master's degree in Computer Science, Information Technology, or a related field. Courses like Planning and Configuring Business Connectivity Services in SharePoint 2019 can help build a foundation in enterprise software and data management.
Business Intelligence Analyst
Business Intelligence Analyst
A Business Intelligence Analyst analyzes data to identify trends and patterns that can help businesses make better decisions. They typically have a bachelor's or master's in Business Administration, Statistics, or a related field. Courses like Planning and Configuring Business Connectivity Services in SharePoint 2019 may be useful for developing skills in data analysis and reporting.
Data Scientist
Data Scientist
A Data Scientist develops and applies statistical models to data to extract meaningful insights. They typically have a master's or PhD in Statistics, Computer Science, or a related field. Courses like Planning and Configuring Business Connectivity Services in SharePoint 2019 may help continue to build a foundation in data modeling and analysis.
Database Administrator
Database Administrator
A Database Administrator maintains and optimizes databases. Database Administrators usually have a bachelor's degree in Computer Science or a related field. Courses in database management can provide a useful foundation for Database Administrators, and courses like Planning and Configuring Business Connectivity Services in SharePoint 2019 help provide a deeper understanding of how to work with enterprise data sources on SharePoint.
Software Architect
Software Architect
A Software Architect designs and develops complex software systems. Software Architects typically have a master's degree in Computer Science or a related field. Courses like Planning and Configuring Business Connectivity Services in SharePoint 2019 may be useful as a way to develop an understanding of software architecture and large-scale enterprise systems.
Web Developer
Web Developer
A Web Developer designs, develops, and maintains websites. Web Developers typically have a bachelor's degree in Computer Science, Information Technology, or a related field. Courses like Planning and Configuring Business Connectivity Services in SharePoint 2019 can help Web Developers build upon their knowledge of how to integrate data sources into websites.
Project Manager
Project Manager
A Project Manager plans, organizes, and manages projects to ensure that they are completed on time and within budget. Project Managers typically have a bachelor's degree in Project Management, Business Administration, or a related field. Courses like Planning and Configuring Business Connectivity Services in SharePoint 2019 may help refine one's skills in planning and organizing large-scale projects.
Information Architect
Information Architect
An Information Architect designs and manages how information is organized and presented. They typically have a bachelor's or master's degree in Information Architecture, Information Science, or a related field. Courses like Planning and Configuring Business Connectivity Services in SharePoint 2019 may be useful in developing an understanding of how to work with content management systems.
For more career information including salaries, visit:
OpenCourser.com/course/745xkt/planning
Reading list
We've selected five books
that we think will supplement your
learning. Use these to
develop background knowledge, enrich your coursework, and gain a
deeper understanding of the topics covered in
Planning and Configuring Business Connectivity Services in SharePoint 2019.
Provides a comprehensive guide to SharePoint administration, including a chapter on BCS. It valuable resource for anyone who is responsible for managing a SharePoint environment.
Provides a comprehensive overview of BCS in SharePoint 2019, covering everything from the basics of BCS to advanced topics such as security and performance tuning.
Provides a practical guide to using BCS in SharePoint 2019, covering everything from the basics of BCS to advanced topics such as security and performance tuning.
Provides a quick reference to BCS in SharePoint 2019, making it a good choice for those who need a quick overview of BCS.
Provides a collection of troubleshooting tips for BCS in SharePoint 2019, making it a good choice for those who are experiencing problems with BCS.
For more information about how these books relate to this course, visit:
OpenCourser.com/course/745xkt/planning
Share
Similar courses
Similar courses are unavailable at this time. Please try again later.
Our mission
OpenCourser helps millions of learners each year. People visit us to learn workspace skills, ace their exams, and nurture their curiosity.
Our extensive catalog contains over 50,000 courses and twice as many books. Browse by search, by topic, or even by career interests. We'll match you to the right resources quickly.
Find this site helpful? Tell a friend about us.
Affiliate disclosure
We're supported by our community of learners. When you purchase or subscribe to courses and programs or purchase books, we may earn a commission from our partners.
Your purchases help us maintain our catalog and keep our servers humming without ads.
Thank you for supporting OpenCourser.
© 2016 - 2025 OpenCourser