Manage your Excel data in SAP HANA with Talend

Virtually every business user knows Microsoft Excel, the spreadsheet component of Microsoft Office. Its ubiquity makes Excel files the most common format for data sharing, and data analysts appreciate Excel's advanced statistics functions and ability to automate actions with macros. Manage Excel data in SAP HANA with Talend's suite of data integration tools.

Connecting to Excel

To connect to an Excel spreadsheet as either a source or as a destination for your data, use the tFileInputExcel component and specify the file’s location.

Learn more about connecting to Excel

More about integrating Excel data

Talend has detailed documentation on how to ETL your Excel data for a better view of the business.

Connecting to SAP HANA

SAP HANA is an in-memory, column-oriented, relational database management system and database server.

To get started, use Talend’s SAP HANA connector. Make sure to have your username, password, and HANA schema ready. From there, Talend makes it easy to work with your SAP HANA and SAP ERP data:

  1. Read and extract fields in a SAP HANA database based on a query
  2. Write, update, make changes, or suppress entries in a SAP HANA database
  3. Execute SQL queries on a SAP HANA database

Read more about establishing an SAP connection

Work with your Excel data

Read an Excel file and extract data Use tJavaRow to enter customized code and the tLogRow component to display data in the Run console. How to extract data from specific Excel cells

Get more from your Excel data

Deliver data your organization can trust... Get started today.

Explore Talend's full suite of apps