<br><b>Code</b>: rsb:print<br><b>Error</b>: Formatter [ extable ] failed in the evaluation of <p> Data Sync ???????????????????????(??)????????????????????????????????sandbox ???????????????????????????????????[datasource] ?Heroku ??PostgreSQL ?????????Salesforce ??????????????Salesforce ????????(Salesforce Connect)???[service] ?????????????????? </p> <h2>??</h2> <p> ???????????????????: <ol> <li>CData Sync (??????????)????[service] ??????????????????? <li>Heroku Postgress ???Heroku app ????Heroku Connect ??????? <li>Salesforce ?????? </ol> <h2>??????????????</h2> <p> CData Sync ?????[datasource] ?Heroku ??PostgreSQL ??????????????????????????Heroku ?????PostgreSQL ???????PostgreSQL ????????????????????????[??]????????? </p> <ol> <li>[???]???????????</li> <li>PostgreSQL ????????????? <p> PostgreSQL ???????Port(???????5432)???????????????????????????????user ???password ??????????????????????????????????????????????????????? </p> </li> <li>??????]??????????????????????????? <img src="[x|UrlRootAbs]/kb/articles/sync-heroku-salesforce-connect-1.png" title="PostgreSQL ????????????" /> </li> <li>[?????]?????????</li> </ol> <h2>[service] ?????</h2> <p> ????????[service] ???????[??]??????????? </p> <ol> <li>[?????]??????[??????]?????????</li> <li>[service] ???????????????????????????????????[service] ?????????????????????????????</li> <li>??????????????? <br><br> [extraconnectionnotessync|def('[extraconnectionnotes|def("")]')] <img src="[x|UrlRootAbs]/kb/articles/sync-heroku-salesforce-connect-2.png" title="???????????(NetSuite ??)?" /> </li> <li>[??????]???????????????????????????</li> <li>[?????]?????????</li> </ol> <h2>[service] ??????????????</h2> <p> Data Sync ??????????????????SQL ???????GUI ?????????? ????????????????[???]??????[??????]???????????? ?????????????????????????????????? <img src="[x|UrlRootAbs]/kb/articles/sync-heroku-salesforce-connect-3.png" title="?????????????????????????" /></p> <h3>?????????????????</h3> <p>????????????????????[????]??????[???????]??????????????????????????????????????????????</p> <img src="[x|UrlRootAbs]/kb/articles/sync-heroku-salesforce-connect-4.png" title="???????????????(NetSuite ??)?" /> <h3>???????????????????????</h3> <p> ????????????????????????????????[??]?????????????????????????????????????????????????????????????????????????????????[??]????????????????????????????????: </p> <ul> <li>??????????????????????? <img src="[x|UrlRootAbs]/kb/articles/sync-heroku-salesforce-connect-5.png" title="Choose which fields to replicate." /> </li> <li>??????????????????????????? <img src="[x|UrlRootAbs]/kb/articles/sync-heroku-salesforce-connect-6.png" title="Add a computed field." /> </li> <li>??????????????????????? <img src="[x|UrlRootAbs]/kb/articles/sync-heroku-salesforce-connect-7.png" title="Add a replication filter." /> </li> </ul> <p> ????????????????????????????SQL ???????????????????: </p> <pre class="brush:sql"> REPLICATE \[[extable]] </pre> <p> ???????????????: </p> <pre class="brush:sql"> REPLICATE \[[extable]] SELECT \[[excol#1]], \[[excol#2]] FROM \[[extable]] WHERE \[[exselectwherecol]] = [exselectwherecolequals] </pre> <h3>???????????????????</h3> <p> [??????]??????????????????????????????????????????????15???????1?????????????? </p> <img src="[x|UrlRootAbs]/kb/articles/sync-heroku-salesforce-connect-8.png" title="???????????" /> <p> ??????????????????[?????]????????????????[datasource] ??????????Salesforce ??????????????????? </p> <h2>???????????[service] [datatype] ?????????????</h2> <p>[datasource] ?Heroku ??PostgreSQL ???????????????????????Heroku ?OData ?????????????Salesforce Connect ???????????????????????????? <h3>Heroku ?OData Service ??????</h3> <p> ????Heroku ??PostgreSQL ????????????[datasource] ??????????????????Heroku External Object ??????? </p> <ol> <li>Heroku ?????????[Connect Add-on] ????????? <li>[External Objects]???????????Heroku External Object ??????????OData Server ?????????????????????????????? <li>OData service URL ???????????????????????????Salesforce Connect ?????????? <li>[Data Sources]??????????????????????????????????????? </ol> <img src="[x|UrlRootAbs]/kb/articles/sync-heroku-salesforce-connect-9.png" title="Heroku Connect ??OData ????????"/> <p> ?????????<a href="https://devcenter.heroku.com/articles/heroku-external-objects-salesforce#setting-up-heroku-external-objects" target=_blank>Heroku documentation</a> ?????????? </p> <h3>Salesforce ????????????</h3> <p> Heroku ?OData ??????????????Salesforce Connect ??????????[datasource] ?????????????????????? </p> <ol> <li>Salesforce ???????????? <li>Administration (??)???????[???]?[????????]?????? <li>??????????????????????: <ul> <li><b>External Data Source</b>: Salesforce UI ???????? <li><b>Name</b>: API ??????? <li><b>Type</b>: Salesforce Connect: OData 4.0 <li><b>URL</b>: Heroku Connect ?OData ??????? <li><b>Format</b>: JSON </ul> <li>?????: <ul> <li><b>Identity Type</b>: Named Principal <li><b>Authentication Protocol</b>: Password Authentication <li><b>Username</b>: Heroku Connect username <li><b>Password</b>: Heroku Connect password </ul> <li>[??]?????? </ol> <img src="[x|UrlRootAbs]/kb/articles/sync-heroku-salesforce-connect-10.png" title="Salesforce ????????????"/> <h3>[service] ?????????</h3> <p> Salesforce ???????????????????????[service] ???????????????????[service] ????????[service] ?????????????????? </p> <ol> <li>?????????????????????? <li>[Validate and Sync]????? <li>[service] ??????????[??]????????? </ol> <img src="[x|UrlRootAbs]/kb/articles/sync-heroku-salesforce-connect-11.png" title="????????????"/> <h2>Salesforce ?????????[service] [datatype] ?????</h2> <p> ???????????????[service] ???????????Salesforce ???????????????????????????????????????? </p> <p>???CData Sync ?<a href="../../sync/download">30???????</a> ??????????Salesforce ????????????! </p>. The error was: The value of the attribute could not be accessed: The attribute does not exist.<br><b>URL</b>: /jp/kb/tech/sql-sync-heroku-salesforce-connect.rst