Windows Data Connectors Guide

On This Page

Supported Sources

SourceAuthenticationWrite back
Google SheetsOAuthYes, with preview and undo
SalesforceOAuthNo, read only
AirtablePersonal access tokenYes, with preview and undo
DatabaseConnection and passwordYes for supported drivers, with preview

Connectors are explicit. Pulling a table is the same class of action as opening a local file. Writing back changes data outside the app and needs an entitlement.


Connect

Open Import from a source. Choose a connector and enter the credentials it asks for. OAuth opens your browser and returns to a local callback. Tokens are stored in the user data folder, encrypted where the platform allows it.

Salesforce needs a Connected App with a callback address on localhost. Airtable needs a token with read and write scopes if you plan to write back.


Pull

A pull reads remote records and converts them to rows. The first heading row is included in the table. Short rows are padded so every row has the same width.

Airtable pulls follow the offset until the last page. Salesforce pulls follow the next records link. Database pulls run one read statement chosen in the form. The result lands in the workbook the app reads, so the grid updates immediately.


Write Back

Choose Preview write back first. The preview plans changes and sends nothing. It matches a local key column to a remote key and lists the fields that would change.

Apply write back sends only the matched updates. Batches follow the documented limits for each service. A rejected record is reported with a reason and does not stop the other records.

Write back needs a licence because it changes data outside the app.


Undo

The app stores the values it read before an update. Undo last write back restores those values and removes the undo record. A write back cannot be undone twice.

Salesforce is read only, so it has no write back and no undo record.


Safety Rules

Queries must be a single read statement. Salesforce SOQL must start with SELECT and identifiers are checked. SQL identifiers are checked and SQLite files open read only.

Remote keys use null-prototype maps and own property checks, so a key called __proto__ is treated as a value and not as an object property. A column called Id in Salesforce cannot redirect a write to another record.