About This Page
This page is part of the Azure documentation. It contains code examples and configuration instructions for working with Azure services.
Bias Analysis
Bias Types:
⚠️
windows_tools
⚠️
missing_linux_example
⚠️
windows_first
Summary:
The documentation demonstrates a Windows bias by exclusively referencing the Microsoft Access ODBC driver, which is only available on Windows. All example connection strings use Windows-style file paths (e.g., C:\mydatabase.accdb), and there is no mention of Linux or cross-platform alternatives for running the Integration Runtime or accessing Microsoft Access data. The prerequisites and setup instructions implicitly assume a Windows environment, and there are no examples or guidance for Linux users.
Recommendations:
- Explicitly state that the Microsoft Access ODBC driver is only available on Windows, and clarify platform limitations in the prerequisites.
- If possible, provide guidance or workarounds for Linux users, such as using third-party ODBC drivers (e.g., MDBTools) or running the Integration Runtime in a Windows container/VM on Linux.
- Include example connection strings and file paths for both Windows and Linux (if supported), or clearly indicate that only Windows is supported.
- Add a section addressing cross-platform considerations and alternatives for non-Windows environments.
Create pull request
Flagged Code Snippets
{
"name": "MicrosoftAccessLinkedService",
"properties": {
"type": "MicrosoftAccess",
"typeProperties": {
"connectionString": "Driver={Microsoft Access Driver (*.mdb, *.accdb)};Dbq=<path to your DB file e.g. C:\\mydatabase.accdb>;",
"authenticationType": "Basic",
"userName": "<username>",
"password": {
"type": "SecureString",
"value": "<password>"
}
},
"connectVia": {
"referenceName": "<name of Integration Runtime>",
"type": "IntegrationRuntimeReference"
}
}
}
"activities":[
{
"name": "CopyFromMicrosoftAccess",
"type": "Copy",
"inputs": [
{
"referenceName": "<Microsoft Access input dataset name>",
"type": "DatasetReference"
}
],
"outputs": [
{
"referenceName": "<output dataset name>",
"type": "DatasetReference"
}
],
"typeProperties": {
"source": {
"type": "MicrosoftAccessSource",
"query": "SELECT * FROM MyTable"
},
"sink": {
"type": "<sink type>"
}
}
}
]
"activities":[
{
"name": "CopyToMicrosoftAccess",
"type": "Copy",
"inputs": [
{
"referenceName": "<input dataset name>",
"type": "DatasetReference"
}
],
"outputs": [
{
"referenceName": "<Microsoft Access output dataset name>",
"type": "DatasetReference"
}
],
"typeProperties": {
"source": {
"type": "<source type>"
},
"sink": {
"type": "MicrosoftAccessSink"
}
}
}
]