Technical Specifications

Supported datasources and file types

The Data X-Ray supports the datasources and file-types set out below

Unstructured Datasources

The Data X-Ray supports the following unstructured datasources

  • Google Drive
  • GSuite
  • Box
  • Email (IMAP)
  • Network Drives
  • Microsoft Office 365
  • Data X-Ray hosted drag and drop
  • Microsoft SQL Server (for column analysis of free text)

Structured Datasources

The Data X-Ray supports the following structured datasources

  • Heroku Postgres
  • Microsoft SQL Server
  • MySQL
  • PostgreSQL

File Types

Amongst others, the Data X-Ray supports the following major file types

  • Word
  • Excel
  • Powerpoint
  • Pages
  • Keynote
  • Word Perfect
  • PDFs

Mime Types

For further technical detail, the Data X-Ray also supports the complete list of the following mime types (Note - audio and video formats only extract metadata)

  • application/applefile
  • application/java-vm
  • audio/vnd.wave
  • audio/x-wav
  • audio/basic
  • audio/x-aiff
  • application/x-midi
  • audio/midi
  • application/vnd.ms-htmlhelp
  • application/x-chm
  • application/chm
  • text/x-c++src
  • text/x-groovy
  • text/x-java-source
  • application/pkcs7-signature
  • application/pkcs7-mime
  • application/timestamped-data
  • text/csv
  • text/tsv
  • text/plain
  • application/x-dbf
  • application/dif+xml
  • image/vnd.dwg
  • application/envi.hdr
  • application/x-ibooks+zip
  • application/epub+zip
  • application/x-msdownload
  • application/x-sharedlib
  • application/x-elf
  • application/x-object
  • application/x-executable
  • application/x-coredump
  • application/atom+xml
  • application/rss+xml
  • application/x-font-adobe-metric
  • application/x-font-ttf
  • application/x-gsc
  • image/x-ozi
  • application/x-pds
  • image/eir
  • application/x-usgs-dem
  • application/aaigrid
  • application/x-bag
  • application/elas
  • application/x-rs2
  • application/x-tsx
  • application/x-lcp
  • image/geotiff
  • application/x-mbtiles
  • application/x-cappi
  • application/x-netcdf
  • application/x-gsag
  • application/x-epsilon
  • application/x-ace2
  • application/jaxa-pal-sar
  • image/x-pcraster
  • application/x-msgn
  • image/arg
  • application/x-hdf
  • image/x-mff
  • application/x-kro
  • image/x-hdf5-image
  • image/x-dimap
  • image/x-srp
  • image/big-gif
  • application/x-envi
  • application/x-cosar
  • application/x-ntv2
  • image/bmp
  • application/x-doq2
  • application/x-bt
  • application/x-kml
  • application/x-gmt
  • application/x-rst
  • application/vrt
  • application/pcisdk
  • application/x-ctg
  • application/x-e00-grid
  • application/x-rik
  • image/ida
  • image/x-mff2
  • application/sdts-raster
  • application/x-snodas
  • image/jp2
  • image/sar-ceos
  • application/terragen
  • application/x-wcs
  • application/leveller
  • application/x-ingr
  • application/x-gtx
  • image/sgi
  • application/x-pnm
  • image/raster
  • application/fits
  • application/x-r
  • image/gif
  • application/x-envi-hdr
  • application/x-http
  • application/x-rmf
  • application/x-ecrg-toc
  • application/aig
  • application/x-rpf-toc
  • image/adrg
  • application/x-srtmhgt
  • application/x-generic-bin
  • application/jdem
  • image/x-airsar
  • application/x-webp
  • application/x-ngs-geoid
  • application/x-pcidsk
  • image/x-fujibas
  • application/x-wms
  • application/x-map
  • image/ceos
  • application/xpm
  • application/x-zmap
  • image/envisat
  • application/x-ers
  • application/x-doq1
  • application/x-isis2
  • application/x-nwt-grd
  • application/x-ppi
  • image/ilwis
  • application/x-isis3
  • application/x-nwt-grc
  • application/x-blx
  • application/gff
  • application/x-ndf
  • image/jpeg
  • application/x-geo-pdf
  • application/x-l1b
  • image/fit
  • application/x-gsbg
  • application/x-sdat
  • application/x-ctable2
  • application/x-grib
  • application/x-coasp
  • application/x-dipex
  • application/grass-ascii-grid
  • image/fits
  • application/x-til
  • application/x-dods
  • image/png
  • application/x-gxf
  • application/x-gs7bg
  • application/x-cpg
  • application/x-lan
  • application/x-xyz
  • image/bsb
  • application/x-p-aux
  • application/dted
  • application/x-rasterlite
  • image/nitf
  • image/hfa
  • application/x-fast
  • application/x-los-las
  • application/geotopic
  • text/iso19139+xml
  • application/x-grib2
  • application/x-hdf
  • text/html
  • application/vnd.wap.xhtml+xml
  • application/x-asp
  • application/xhtml+xml
  • application/x-hwp-v5
  • image/bpg
  • image/x-bpg
  • image/icns
  • image/png
  • image/vnd.wap.wbmp
  • image/x-jbig2
  • image/bmp
  • image/x-xcf
  • image/gif
  • image/x-icon
  • image/x-ms-bmp
  • image/vnd.adobe.photoshop
  • image/tiff
  • image/webp
  • text/vnd.iptc.anpa
  • application/x-isatab
  • application/vnd.apple.keynote
  • application/vnd.apple.iwork
  • application/vnd.apple.numbers
  • application/vnd.apple.pages
  • image/jpeg
  • message/rfc822
  • application/x-matlab-data
  • application/mbox
  • application/vnd.ms-outlook-pst
  • image/emf
  • application/x-msaccess
  • application/x-ms-owner
  • application/x-tika-msoffice-embedded; format=ole10_native
  • application/msword
  • application/vnd.visio
  • application/vnd.ms-project
  • application/x-tika-msworks-spreadsheet
  • application/x-mspublisher
  • application/vnd.ms-powerpoint
  • application/x-tika-msoffice
  • application/sldworks
  • application/x-tika-ooxml-protected
  • application/vnd.ms-excel
  • application/vnd.ms-outlook
  • application/vnd.ms-excel.workspace.3
  • application/vnd.ms-excel.workspace.4
  • application/vnd.ms-excel.sheet.2
  • application/vnd.ms-excel.sheet.3
  • application/vnd.ms-excel.sheet.4
  • application/vnd.ms-tnef
  • application/x-tnef
  • application/ms-tnef
  • image/wmf
  • application/onenote; format=one
  • application/vnd.ms-powerpoint.template.macroenabled.12
  • application/vnd.ms-excel.addin.macroenabled.12
  • application/vnd.openxmlformats-officedocument.wordprocessingml.template
  • application/vnd.ms-excel.sheet.binary.macroenabled.12
  • application/vnd.openxmlformats-officedocument.wordprocessingml.document
  • application/vnd.ms-powerpoint.slide.macroenabled.12
  • application/vnd.ms-visio.drawing
  • application/vnd.ms-powerpoint.slideshow.macroenabled.12
  • application/vnd.ms-powerpoint.presentation.macroenabled.12
  • application/vnd.openxmlformats-officedocument.presentationml.slide
  • application/vnd.ms-excel.sheet.macroenabled.12
  • application/vnd.ms-word.template.macroenabled.12
  • application/vnd.ms-word.document.macroenabled.12
  • application/vnd.ms-powerpoint.addin.macroenabled.12
  • application/vnd.openxmlformats-officedocument.spreadsheetml.template
  • application/vnd.ms-xpsdocument
  • application/vnd.ms-visio.drawing.macroenabled.12
  • application/vnd.ms-visio.template.macroenabled.12
  • model/vnd.dwfx+xps
  • application/vnd.openxmlformats-officedocument.presentationml.template
  • application/vnd.openxmlformats-officedocument.presentationml.presentation
  • application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
  • application/vnd.ms-visio.stencil
  • application/vnd.ms-visio.template
  • application/vnd.openxmlformats-officedocument.presentationml.slideshow
  • application/vnd.ms-visio.stencil.macroenabled.12
  • application/vnd.ms-excel.template.macroenabled.12
  • application/vnd.ms-word2006ml
  • application/vnd.ms-spreadsheetml
  • application/vnd.ms-wordml
  • audio/mpeg
  • video/x-m4v
  • application/mp4
  • video/3gpp
  • video/3gpp2
  • video/quicktime
  • audio/mp4
  • video/mp4
  • application/x-netcdf
  • application/x-vnd.oasis.opendocument.presentation
  • application/vnd.oasis.opendocument.chart
  • application/x-vnd.oasis.opendocument.text-web
  • application/x-vnd.oasis.opendocument.image
  • application/vnd.oasis.opendocument.graphics-template
  • application/vnd.oasis.opendocument.text-web
  • application/x-vnd.oasis.opendocument.spreadsheet-template
  • application/vnd.oasis.opendocument.spreadsheet-template
  • application/vnd.sun.xml.writer
  • application/x-vnd.oasis.opendocument.graphics-template
  • application/vnd.oasis.opendocument.graphics
  • application/vnd.oasis.opendocument.spreadsheet
  • application/x-vnd.oasis.opendocument.chart
  • application/x-vnd.oasis.opendocument.spreadsheet
  • application/vnd.oasis.opendocument.image
  • application/x-vnd.oasis.opendocument.text
  • application/x-vnd.oasis.opendocument.text-template
  • application/vnd.oasis.opendocument.formula-template
  • application/x-vnd.oasis.opendocument.formula
  • application/vnd.oasis.opendocument.image-template
  • application/x-vnd.oasis.opendocument.image-template
  • application/x-vnd.oasis.opendocument.presentation-template
  • application/vnd.oasis.opendocument.presentation-template
  • application/vnd.oasis.opendocument.text
  • application/vnd.oasis.opendocument.text-template
  • application/vnd.oasis.opendocument.chart-template
  • application/x-vnd.oasis.opendocument.chart-template
  • application/x-vnd.oasis.opendocument.formula-template
  • application/x-vnd.oasis.opendocument.text-master
  • application/vnd.oasis.opendocument.presentation
  • application/x-vnd.oasis.opendocument.graphics
  • application/vnd.oasis.opendocument.formula
  • application/vnd.oasis.opendocument.text-master
  • application/pdf
  • application/zlib
  • application/x-gzip
  • application/x-bzip2
  • application/x-compress
  • application/x-java-pack200
  • application/x-lzma
  • application/deflate64
  • application/x-lz4
  • application/x-snappy
  • application/x-brotli
  • application/gzip
  • application/x-bzip
  • application/x-xz
  • application/x-tar
  • application/java-archive
  • application/x-arj
  • application/x-archive
  • application/zip
  • application/x-cpio
  • application/x-tika-unix-dump
  • application/x-7z-compressed
  • application/x-rar-compressed
  • application/rtf
  • application/x-sas-data
  • video/x-flv
  • application/x-quattro-pro; version=9
  • application/vnd.wordperfect; version=5.1
  • application/vnd.wordperfect; version=5.0
  • application/vnd.wordperfect; version=6.x
  • application/x-xliff+xml
  • application/x-xliff+zip
  • application/xml
  • image/svg+xml
  • application/x-fictionbook+xml
  • audio/x-oggflac
  • audio/x-flac
  • audio/ogg
  • application/kate
  • application/ogg
  • video/daala
  • video/x-ogguvs
  • video/x-ogm
  • audio/x-oggpcm
  • video/ogg
  • video/x-dirac
  • video/x-oggrgb
  • video/x-oggyuv
  • audio/opus
  • audio/ogg; codecs=opus
  • audio/ogg; codecs=speex
  • audio/speex
  • video/theora
  • audio/vorbis
If the datasource or file type that you require is not listed out above, please do get in contact at [email protected]. We'd love to discuss your use case and are adding additional functionality, guided by our clients, on a regular basis.