-
1. Re: Salesforce connector
jdoyle Jun 4, 2009 12:05 PM (in response to camdk3)The connector is delivered with Teiid, and the associated importer is delivered with Teiid designer, so if you've downloaded them you've got the connector. We have yet to put any doc on this out yet as other tasks have been the priority.
If you've got the Designer running you can invoke the importer to create a model from the Import menu. The importer creates a relational model of your Salesforce metadata. Once you've done that you can query the model much like any database.
Give it a shot and let me know if you need help.
~jd -
2. Re: Salesforce connector
camdk3 Jun 9, 2009 11:05 AM (in response to camdk3)Ok, i've got the importer connecting to my test salesforce instance,
but when i get to the "Target Model Selection" i select my model
and it defaults Location but then i get:
<Missing message for key "ModelSelectionPage.virtualModelMessage" in: com.metamatrix.modeler.modelgenerator.salesforce.ui.i18n>
At the moment the model is just an empty model, do i need to configure something in the model first?
Thanks!
Dan -
3. Re: Salesforce connector
jdoyle Jun 9, 2009 11:38 AM (in response to camdk3)Looks like you are selecting a virtual model, not a physical model. The SF importer generates a physical model that you can create a virtual on top of, but you can't use the importer to create or populate a physical model.
The typical usage pattern is to allow the importer to create a new model for you. Try typing a model name for a model that doesn't exist in your project.
~jd -
4. Re: Salesforce connector
camdk3 Jun 9, 2009 11:38 AM (in response to camdk3)My mistake - The model i was loading into was a View not a Source model. I've not yet got up to speed on the differences!
-
5. Re: Salesforce connector
jdoyle Jun 9, 2009 11:39 AM (in response to camdk3)Doh, typed faster than I thought.
you can't use the importer to create or populate a VIRTUAL model.
~jd -
6. Re: Salesforce connector
camdk3 Jun 10, 2009 10:55 AM (in response to camdk3)It all works, great stuff.
Out of interest, can you write back into the Salesforce connector? That would be cool...
Thanks!
Dan -
7. Re: Salesforce connector
jdoyle Jun 10, 2009 11:05 AM (in response to camdk3)Yes, the connector supports insert, update and delete, as determined by the Salesforce Object. The connector is implemented via the web service interfaces, so if you look at the doc there you can determine which objects support which operations. We also exposed this info via metadata properties on the tables (see the supportsXXX metadata properties).
http://www.salesforce.com/us/developer/docs/api/index.htm
~jd -
8. Re: Salesforce connector
camdk3 Jun 10, 2009 11:07 AM (in response to camdk3)hehe, thats brilliant.
-
9. Re: Salesforce connector
camdk3 Jun 11, 2009 11:43 AM (in response to camdk3)One more question. Does it support batching of updates?
-
10. Re: Salesforce connector
jdoyle Jun 11, 2009 1:14 PM (in response to camdk3)Sorry, it does not.
~jd -
11. Re: Salesforce connector
camdk3 Jun 12, 2009 3:29 AM (in response to camdk3)Ok no probs.
I just spent several months writing custom java code to go from our transform tool into salesforce in a batching fashion, and it's not pretty! -
12. Re: Salesforce connector
rareddy Jun 12, 2009 9:30 AM (in response to camdk3)jdoyle: is this something we have on roadmap with Salesforce Connector?
-
13. Re: Salesforce connector
jdoyle Jun 12, 2009 10:27 AM (in response to camdk3)It's not, but I'll add a feature request Jira for it.
-