@flatfile/plugin-foreign-db-extractor
v0.1.1
Published
A plugin for extracting MSSQL DBs from a .bak file.
Downloads
146
Maintainers
Keywords
Readme
@flatfile/plugin-foreign-db-extractor
The @flatfile/plugin-foreign-db-extractor
plugin listens for .bak
files uploaded to Flatfile, then restores the .bak
to a Flatfile hosted Microsoft SQL Server database making the data available in the "Uploaded Files" view as a readonly File Workbook with each database table viewable as a Flatfile Sheet. The data is accessible the same as any other extracted file (i.e. .csv
or .xlsx
), however the source is coming from the restored database. This plugin is useful for customers who have very large datasets stored in a Microsoft SQL Server database and access that data in a Flatfile Workbook.
Get Started
Access to this feature on the Flatfile Platform need to be enabled per account. Please reach out to our support team to discuss using the Foreign DB plugin!
npm i @flatfile/plugin-foreign-db-extractor @flatfile/listener
import type { FlatfileListener } from '@flatfile/listener'
import { foreignDBExtractor } from '@flatfile/plugin-foreign-db-extractor';
export default function (listener: FlatfileListener) {
listener.use(foreignDBExtractor());
}