The post below was designed for the BLOB data type in SQL Server (2014) but similar concepts should work for other data sources as well.
Setup:
in SQL Server Mgmt Studio
CREATE TABLE [BLOBS](
[Id] [int] IDENTITY(1,1) NOT NULL,
[Data] varbinary NULL,
[type] varchar NULL
CONSTRAINT [PK_BLOBS] PRIMARY KEY CLUSTERED
(
[Id] ASC
) ) ON [PRIMARY]
insert a few records based on the date types you want to try:
INSERT BLOBS( Data, type )
SELECT *,‘jpg’ FROM OPENROWSET (BULK ‘C:\FOLDER\FILENAME.jpg’, SINGLE_BLOB) rs
INSERT BLOBS( Data, type )
SELECT *,‘csv’ FROM OPENROWSET (BULK ‘C:\FILDER\FILENAME.csv’, SINGLE_BLOB) rs
…
The data itself when try to look at in SQL Server is not very meaningful:
With a snapLogic pipeline though, you can control what you want to have happen with it in a simple peipline that selects the data and converts $data into $content.
SQL Select:
data to content:
Router
Document to Binary (both same configuration)
CSV Parser (data preview):
File Writer
I built in the bottom path as a future catch bucket for other data types added to my BLOB storage table.
