Applies to
- Business
- Enterprise
Capabilities
Who can use this capability
To use Data Shuttle, you must:
- Have Owner, Admin, or Editor permissions on the target sheet.
- Have Data Shuttle Premium Application permissions enabled in User Management by your Smartsheet System Admin.
To contact your sales representative and learn more, visit the Data Shuttle Marketplace.
Data Shuttle Integrations: SAP ERP
Overview
SAP ERP is an enterprise resource planning software developed to bring together your accounting, financials, purchasing, inventory, sales, and customer relationships data for reporting and analytics.
Use cases
| Use case | Details |
|---|---|
| Time tracking and resource planning | Bring employee data into Smartsheet and use Resource Management to assign projects, balance workloads, and build strong teams based on expertise. |
| Inventory management | Bring in your part information into Smartsheet and drive reminders, reports, dashboards with Smartsheet automations to ensure you have the flexibility and visibility you need. Leverage DataTable to track millions of parts in Smartsheet. |
| Budget tracking | Track budgets and actuals against projects by combining your Smartsheet project plans with the financial data from SAP ERP. |
Export your data from SAP ERP
To export table data as a CSV or XLSX
- Choose the More Actions icon before selecting Export.
- In the dialog, provide a name for your file and select the file type you prefer. You can decide on the scope and format of your data if you wish.
- Select OK to initiate the download.
Import your data into Smartsheet
Once you've got your report, save it in your Google Drive (shared or personal), OneDrive, SharePoint, or Box (shared or personal). You can then head to DataShuttle and begin building your upload workflow.
Select your preferred storage drive in the Source Location dropdown. You'll need to authenticate to the system the first time you ask Data Shuttle to connect with it. Use the filters and mapping steps to select the exact data you want to upload, and schedule your workflow to run as often as you require your data to be updated.