Extract data from pdf and push into sql table -- 2

Project Document: Read PDF, Extract Data and Store in SQL Server using C# and WebAPI

Objective:
The objective of this project is to read PDF files from a specified location, extract data row and column wise, and store the data in a SQL Server table row and column wise. The data can then be accessed using a WebAPI.

Technologies:

C# (itext7,itextsharp,pdfbox.net,pdfsharp,pdfpig,
Tesseract, pdfsharp,magick.net,ocropus)
SQL Server
WebAPI
Python (Tabula-py, Camelot, pdfplumber,pdfminer.six)
Java (Apache pdfbox)
Requirements:

Visual Studio 2019 or higher
SQL Server Management
Newtonsoft.Json NuGet package

Select file from particular location them perform below steps:-

1. First check password in pdf
2. Remove it
3. Then check image or not
4. If image use ocr
5. If not then extract data row and column wise
6. Push in sql table as per the pdf format



Use pdf for example
1.Bank statements
2. Credit card statement
3. Utility bill
4. Insurance policy
Etc etc