Intro
Microsoft Access is a Database Management System (DBMS) that is a part of the Microsoft Office suite of applications. The Microsoft Access connector extracts data from an Access database file using the provided database query. You can connect to your Microsoft Access SFTP Connector account in the Data Center. This topic discusses the fields and menus that are specific to the Microsoft Access SFTP Connector connector user interface. To add DataSets, set update schedules, and edit DataSet information, see Adding a DataSet Using a Data Connector.Prerequisites
To connect to your Microsoft Access SFTP Connector account and create a DataSet, you must have the following:- Host Name
- Port Number
- Username
- Password
Connecting to Your Microsoft Access SFTP Connector Account
This section enumerates the options in the Credentials and Details panes on the Microsoft Access SFTP Connector Connector page. The components of the other panes on this page, Scheduling, and Name & Describe Your DataSet, are universal across most connector types and are discussed in greater length in Adding a DataSet Using a Data Connector.Credentials Pane
This pane contains fields for entering credentials to connect to your Microsoft Access SFTP Connector account. The following table describes what is needed for each field:Field | Description |
|---|---|
Host Name | Enter the SFTP Hostname (e.g. sftp.example.com ). |
Port Number | Enter the SFTP port number. |
Username | Enter the SFTP Username. |
Password | Enter the SFTP Password. |
Details Pane
This pane contains a primary Reports menu, along with various other menus which may or may not appear depending on the report type you select.Menu | Description |
|---|---|
File Name | Enter the complete file path with the extension. For example, ‘/home/test/TestSheet.accdb’. |
Is Password Protected? | Select ‘Yes’ if the file is password protected. |
File Password | Enter the file password. |
Query | Enter the query to be executed. For example, ‘select * from employee;’. |