Import data into Pyramid Analytics

daoppong
✭✭✭
Does anyone know how to import smartsheet data into Pyramid Analytics application? I'm working with a team, and we have some data in Smartsheet, which we are bringing into this application. Any thoughts and ideas will be appreciated.
Answers
-
I am not familiar with Pyramid Analytics. But Smartsheet provides a number of ways to export data:
- Manual from the sheet `File -> Export` and choose your format
- Data Shuttle to setup Import/Export automatons
- ODBC connections
- Writing your own program using the Smartsheet API to directly access data as JSON, Excel or CSV
- Other third-party connections found in Smartsheets Partners listings. I have never used any of these, but CData is an example.
For myself, I would first look to Data Shuttle and then then writing a custom API program.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.1K Get Help
- 430 Global Discussions
- 149 Industry Talk
- 490 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 154 Just for fun
- 74 Community Job Board
- 499 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives