Extract Data from PDF and load data into SQL Server Database.

• swetha.sql1

  SSC Enthusiast

  Points: 172

  More actions

  August 13, 2018 at 5:09 pm

  #376050

  Hello Everyone!

  Can someone suggest me Third party tools to extract data from PDF and load into SQL server. I saw R in 2017, any suggestions on this?

  I tried PDFtables.com and tried to convert my PDF to Excel and then to SQL Server. i Tried Tabula as well.

  Is there anything that we can use ssis to do this?

  Regards,
  Swetha V

• Joe Torre

  SSChampion

  Points: 10248

  More actions

  August 15, 2018 at 12:06 pm

  #2001955

  I know Power BI can extract tabular data from web pages but it doesn't work on PDF. In a quick search I found Tabula

• GaffneyJ

  SSC Eights!

  Points: 856

  More actions

  August 16, 2018 at 9:42 am

  #2002104

  An Example of a 3rd party software we use is called "ChronoScan" But i'm sure their is many others out there.