STEP 1
Connect Archive and Microsoft SQL Server
Save credentials in WEXTL once. We store them encrypted and reuse the authorization across every workflow [3]. No coding or API skills required.
Archive and Microsoft SQL Server Integration
Combine the built-in Archive node with Microsoft SQL Server on the WEXTL® visual workflow builder. Drop Archive anywhere in your Microsoft SQL Server automation to run its logic between steps — the two live side by side on the same canvas, so you build the whole flow visually without a single line of code.
3-day trialCancel anytimeUp to 10 minutes quick set up
- GDPR
- Data Encryption
- 2FA
- Local Data Region
Learn about Archive and Microsoft SQL Server
Detailed info you need to know about Archive and Microsoft SQL Server integrations in WEXTL. Explore which modules apps support and how you connect them.
Archive
Compress, decompress, and archive files inside a workflow. Create and extract ZIP, tar, tar.gz, and gzip archives, or compress raw data on the fly. [5]
Microsoft SQL Server
Read and change rows in a Microsoft SQL Server or Azure SQL database, run your own query, and start a workflow when new rows appear. Works with SQL Server 2016 or newer, Azure SQL Database, and Amazon RDS for SQL Server. [6]
How to connect Archive to Microsoft SQL Server
Set up your Archive and Microsoft SQL Server integration in 3 simple steps [2] — no coding required. Up to 10 minutes setup.
STEP 2
Build a workflow
Paste selected Archive and Microsoft SQL Server nodes onto the canvas [4], or describe what you want and WEXTL wires the flow together with AI Builder.
STEP 3
Map your data
Choose which fields need to sync between Archive and Microsoft SQL Server. Use filters or leverage a JS custom code step in between — everything is on the canvas.
How does the integration between Archive and Microsoft SQL Server work in WEXTL?
WEXTL exposes actions and triggers for Archive and Microsoft SQL Server that help you connect apps and automate repetitive tasks [1]. A trigger is an event that happens, an action — a step that performs when the event has occurred.
Microsoft SQL Server (built-in)Archive (built-in)
Microsoft SQL Server modules
- Delete rowsDelete the rows that match your conditions.M
- Execute a queryRun your own T-SQL, with values passed as parameters.M
- Insert a rowAdd a row to a table and get its new identity value back.M
- Select rowsRead rows from a table with simple conditions, a sort and a limit.M
- Update rowsChange the rows that match your conditions.M
- Watch rowsStart a workflow when new or changed rows appear in a table. Checks on your workflow schedule.M
Archive modules
- Create TAR / TAR.GZCombine one or more files into a tar or tar.gz archive.A
- Create ZIPCombine one or more files into a ZIP archive.A
- Deflate CompressCompress data using the deflate method.A
- Extract TAR / TAR.GZExtract the files from a tar or tar.gz archive, as separate items or one bundle.A
- Extract ZIPExtract the files from a ZIP archive, as separate items or one bundle.A
- Gunzip DecompressDecompress a gzip file back into its original data.A
- Gzip CompressCompress data into a gzip file.A
- Inflate DecompressDecompress deflate-compressed data back into its original form.A
Explore alternative integrations
There are other apps [9] supported by WEXTL that can be paired with Archive and Microsoft SQL Server integrations. Pick any from the list below if the current combination isn't the one you need.
Frequently asked questions
Common questions about connecting Archive and Microsoft SQL Server.
Connect your Archive and Microsoft SQL Server accounts once, pick a trigger in one app and an action in the other, then map the fields so data flows automatically between them. [3]
Example: when Microsoft SQL Server's "Watch rows" fires, WEXTL can "Create TAR / TAR.GZ" in Archive. Archive has 8 actions (including Create TAR / TAR.GZ, Create ZIP, and Deflate Compress); Microsoft SQL Server has 5 actions (including Delete rows, Execute a query, and Insert a row). Add filters and transforms between steps when you need them. [1]
Yes — the integration works in both directions. Use each app's triggers to start a workflow and the other app's actions to update it. [2]
No. Archive-to-Microsoft SQL Server automations are built visually on the canvas. You can optionally add custom JavaScript with Functions when you need advanced logic. [4]
Yes. Trigger-based automations start the moment Archive (or Microsoft SQL Server) fires a new event — webhook-backed apps run within seconds, and polling-only apps re-check on a schedule you control. [7]
A first automation typically takes 5–10 minutes: connect each app's credential once, drop a trigger + action onto the canvas, map the fields, and turn the workflow on.
You can build your Archive + Microsoft SQL Server automation on a 3-day trial with every feature unlocked. Cancel anytime. For your protection, a small deposit is charged to your card when your trial starts. It counts toward your first payment and is non-refundable. [8]
References
List of sources used to gather information about the Archive and Microsoft SQL Server integration.
- Archive and Microsoft SQL Server integration source code, module specs and credentials implementation.
- Our Archive and Microsoft SQL Server integration documentation, structured input and output parameters, scopes, and authentication methods.
- Official vendor API documentation for Archive and Microsoft SQL Server — used to verify field meanings, authentication flows, and anything our own specs don't fully capture.
- WEXTL® visual workflow builder, anonymized data from our technical support team.
- Archive integration information
- Microsoft SQL Server integration information
- WEXTL® Scheduling
- WEXTL® Pricing and Trial
- WEXTL® Apps Library