- Posts: 118
- Thank you received: 2
Load pdf info sql server ?
6 years 4 months ago #16886
by cgetz
Load pdf info sql server ? was created by cgetz
I have a task of loading a .pdf document into a sql server database.
I can do this manually however ti would involve converting the .pdf to .xls and then loading the .xls into sql server using visual importer.
However this is something that would happen more than once a day. Suggestions on how to automate this ?
Thanks
www.tccustomerexpress.com/docs/ml_contracts/CDE-Report.pdf
I can do this manually however ti would involve converting the .pdf to .xls and then loading the .xls into sql server using visual importer.
However this is something that would happen more than once a day. Suggestions on how to automate this ?
Thanks
www.tccustomerexpress.com/docs/ml_contracts/CDE-Report.pdf
Please Log in or Create an account to join the conversation.
6 years 4 months ago #16887
by admin
Mike
ETL Architect
Replied by admin on topic Load pdf info sql server ?
My suggestion is to use one of command line utilities or python libraries to extract text from pdf than load it into the database
okfnlabs.org/blog/2016/04/19/pdf-tools-e...-data-from-pdfs.html
okfnlabs.org/blog/2016/04/19/pdf-tools-e...-data-from-pdfs.html
Mike
ETL Architect
Please Log in or Create an account to join the conversation.
6 years 4 months ago #16888
by admin
Mike
ETL Architect
Replied by admin on topic Load pdf info sql server ?
We will try to find easier solution I think it will benefit a lot of users
Mike
ETL Architect
Please Log in or Create an account to join the conversation.
6 years 4 months ago #16898
by admin
Mike
ETL Architect
Replied by admin on topic Load pdf info sql server ?
Mike
ETL Architect
Please Log in or Create an account to join the conversation.
- Peter.Jonson
-
- Offline
- Platinum Member
-
6 years 4 months ago #16904
by Peter.Jonson
Peter Jonson
ETL Developer
Replied by Peter.Jonson on topic Load pdf info sql server ?
Peter Jonson
ETL Developer
Please Log in or Create an account to join the conversation.