SFDC data connector- report
Hi all,
I have a quick question on SFDC data connector. I’m trying to pull SFDC Task object data in Domo which includes our TLG call and dial data. However, the task object seems to be too big to be imported. I only selected 5 fields in the object and it took forever to import.
I saw another option to import SFDC is through reports. Where do I have to save the report I want to pull in SFDC so that the report can show up in the drop down list? I have a lot of random reports showing up in the drop down list and I have no idea how to include the one I want to pull. Saw this post in help but don’t know what does Account reports mean.. http://wiki.domo.com/confluence/display/428BA51/April+2014+Release+2
Thanks!
Jeanine
Best Answer
-
And lastly to add to your questions,
REPORTS can only be added into domo when these reports are tabular only.
-JP
1
Answers
-
This is one way I would go about it.
1) I would acquire a replication tool that syncs SFDC data to a database like MySql, Oracle, or SQL server.
2) Multiple options here:
a) use Workbench to upload data from your DB to DOMO
b) upload directly from domo
c) Partition the data with a view (limit the data set size) and upload as an append.
Let me know if this helps.
regards,
JP
BI Consultant
1 -
And lastly to add to your questions,
REPORTS can only be added into domo when these reports are tabular only.
-JP
1 -
Yeah I changed the report type to tabular and it showed up. Thanks!!
1
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 296 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.9K Transform
- 100 SQL DataFlows
- 614 Datasets
- 2.2K Magic ETL
- 3.8K Visualize
- 2.5K Charting
- 729 Beast Mode
- 53 App Studio
- 40 Variables
- 677 Automate
- 173 Apps
- 451 APIs & Domo Developer
- 45 Workflows
- 8 DomoAI
- 34 Predict
- 14 Jupyter Workspaces
- 20 R & Python Tiles
- 394 Distribute
- 113 Domo Everywhere
- 275 Scheduled Reports
- 6 Software Integrations
- 121 Manage
- 118 Governance & Security
- Domo Community Gallery
- 32 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 108 Community Announcements
- 4.8K Archive