Microsoft Access

Suggest Edits

Connector Details

Connector AttributesDetails
NameMicrosoft Access
DescriptionMicrosoft Access is a powerful relational database management system (RDBMS) that provides individuals and organizations with an intuitive platform for creating, managing, and analyzing data. With its user-friendly interface and robust features, Access allows users to build custom database applications without the need for advanced programming skills. Users can easily design tables, forms, queries, and reports to organize and manipulate data according to their specific requirements. Access also offers integration with other Microsoft Office applications, enabling seamless data sharing and collaboration across different platforms. Whether used for personal projects, small businesses, or enterprise solutions, Microsoft Access serves as a versatile and scalable solution for effectively managing data and improving productivity.
Connector TypeClass B

Features

Feature NameFeature Details
Load StrategiesFull Load
Metadata ExtractionSupported
Data AcquisitionSupported
Data PublishingNot Supported
Automated Schema Drift HandlingNot Supported

Source Connection Attributes

Connection ParametersData TypeExample
Connection NameStringMicrosoftAccessConnector
FilepathString/path/to/your/database.mdb
Bronze Schema (Optional)String
Silver Schema (Optional)String

Connector Specific Configuration Details

  1. Microsoft Access connector has optional values such as Bronze Schema and Silver Schema
  2. Source Configuration to place the access file.
    The access file needs to exist in a file location accessible from the Databricks workspace file system.
    a) Any location on DBFS
    b) Any directory in the attached data lake which is mounted to the Databricks workspace.
  1. More details around this connector

Screenshot To Use Connector

Updated about 2 months ago