Only Salesforce Administrators can install the app from the Salesforce AppExchange. Use the /chatter command in Slack to send updates to Chatter. Microsoft Excel features calculations, graphing tools, pivot tables, and a macro programming language that allows users to work with data in many of the ways that suit their needs, whether on a Windows machine or a Macintosh machine. This article walks through creating a DSN for Salesforce Chatter data in iODBC and accessing Salesforce Chatter data in Microsoft Excel, all on a machine running Mac OS X. Installing the CData ODBC Drivers on Mac OS X The CData ODBC Driver for Salesforce Chatter is preconfigured for the iODBC driver manager, as are many other products like Microsoft Excel. This makes the driver easy to use with these tools. Licensing the Driver In a terminal run the following commands to license the driver. To activate a trial, omit the key input. Cd '/Applications/CData ODBC Driver for Salesforce/bin' sudo./install-license Creating a DSN for iODBC Installing the ODBC Driver for Salesforce Chatter registers the driver with the iODBC driver manager, so the only remaining step is to use the iODBC Administrator to supply the necessary connection properties in a DSN. The driver installation automatically creates a User DSN. However, modifying a system DSN requires elevated permissions. • Open a terminal and enter the following command to start the iODBC Administrator with the necessary permissions: sudo /Applications/iODBC/iODBC Administrator.app/Contents/MacOS/iODBC Administrator • On the Users tab, select CData SalesforceChatter Source. • Click the Add button to enter connection properties as key-value pairs. Salesforce Chatter uses OAuth 2.0 authentication. To authenticate to Salesforce Chatter via OAuth 2.0, you will need to obtain the OAuthClientId, OAuthClientSecret, and CallbackURL by registering an app with Salesforce Chatter. If you wish to authenticate using OAuth, you will need to add an additional key-value pair to the DSN to ensure that the OAuth flow can execute properly: Keyword Value Other CheckPromptMode=False Accessing Salesforce Chatter Data from Microsoft Excel You can use the DSN configured above to access Salesforce Chatter data from Microsoft Excel. • Open Microsoft Excel and open a spreadsheet (new or existing). • Navigate to the data ribbon and select New Database Query From Database • Select the User or System DSN that you previously configured and click OK. • Build your SQL query in the Microsoft Query wizard: • Click Return Data to execute the query and pull data into Excel. Using the CData ODBC Driver for Salesforce Chatter, you can easily pull your Salesforce Chatter data directly into Excel. Once there, you can leverage all of the powerful features native to Excel to analyze, report, transform your Salesforce Chatter data, and more! Available in: both Salesforce Classic () and Lightning Experience Available in: Essentials, Group, Enterprise, Professional, Performance, Unlimited, Contact Manager, and Developer Editions For more information, see. Good high school games for mac. Use Chatter Desktop to post and comment in Chatter, and receive updates about your groups and the people, records, and files you follow. Chatter Desktop also supports chat, private Chatter messages, and displays Chatter updates and private messages as popup notifications in your Windows taskbar or Mac OS X Dock.
0 Comments
Leave a Reply. |