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.7K Product Ideas
- 1.7K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 295 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.8K Transform
- 97 SQL DataFlows
- 608 Datasets
- 2.1K Magic ETL
- 3.8K Visualize
- 2.4K Charting
- 710 Beast Mode
- 49 App Studio
- 39 Variables
- 667 Automate
- 170 Apps
- 446 APIs & Domo Developer
- 44 Workflows
- 7 DomoAI
- 33 Predict
- 13 Jupyter Workspaces
- 20 R & Python Tiles
- 391 Distribute
- 111 Domo Everywhere
- 274 Scheduled Reports
- 6 Software Integrations
- 115 Manage
- 112 Governance & Security
- Domo Community Gallery
- 31 Product Releases
- 9 Domo University
- 5.3K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 103 Community Announcements
- 4.8K Archive