5

Python to Load Binary Documents to SAP HANA

Python

Python is a widely used general-purpose, high-level programming language. Its design philosophy emphasizes code readability, and its syntax allows programmers to express concepts in fewer lines of code than would be possible in languages such as C++ or Java.

Unstructured Data

What is Unstructured Data?. Unstructured data (or unstructured information) refers to information that either does not have a pre-defined data model or is not organized in a pre-defined manner. Unstructured information is typically text-heavy, but may contain data such as dates, numbers, and facts as well.

How to Load PDF or XML files (Unstructured data) to SAP HANA by using Python

Installing Python

1) Download Python for windows from the following link click here

2) Download Python odbc drivers from the following link click here

    2016-02-15_15-18-10

3) Install python in windows directory C:\Python33\ as shown in the picture. Click on finish to complete the installation process.

 2016-02-15_15-18-342016-02-15_15-18-49

2016-02-15_15-19-052016-02-15_15-21-39

4) Next install downloaded Python ODBC driver. Click on finish to complete the installation process.

2016-02-15_15-22-30

Now we are ready to load the (PDF or XML ) Unstructured files to SAP HANA Cloud Platform. Before doing that make sure that you followed the prerequisite steps.

Creating tunel to SAP HANA Cloud Platform

Creating ODBC datasource to SAP HANA Cloud Platform

If you are loading data to SAP HANA on Premises. Then you can skip the step of creating the tunel.

How to Load PDF file to SAP HANA

Post a Comment

  1. It is one of the top compensation giving fields occupation profiles like Business Analysts, Business Intelligence Analysts, SAS Data Analysts, Big Data Scientists, IBM Data Analysts, Data Mining Engineer, Enterprise Data Architect, Hadoop Engineer, Senior Data Scientist, Data Warehouse Architect, Senior Big Data Analysts, and so on. ExcelR Data Science Courses

    ReplyDelete
  2. aws training in hyderabad
    https://360digitmg.com/amazon-web-services-aws-training-in-hyderabad
    AWS training will give the students obtain expertise in the theories of AMI Creation, EBS Persistent Storage, Amazon Storage Services S3, Route 53, AWS EC2 and AWS S3 Instances & further high-level concepts.

    ReplyDelete
  3. wonderful article. Very interesting to read this article.I would like to thank you for the efforts you had made for writing this awesome article. This article resolved my all queries.
    Data Science Course

    ReplyDelete
  4. Very interesting to read this article.I would like to thank you for the efforts you had made for writing this awesome article. This article inspired me to read more. keep it up.
    Correlation vs Covariance
    Simple linear regression

    ReplyDelete
  5. Amazing Article ! I would like to thank you for the efforts you had made for writing this awesome article. This article inspired me to read more. keep it up.
    Simple Linear Regression
    Correlation vs covariance
    data science interview questions
    KNN Algorithm
    Logistic Regression explained

    ReplyDelete

 
Top