SQL Access to Oracle Service Cloud Data from On-Premise ApplicationsĪt this point, you have a direct connection to live Oracle Service Cloud data from your Tableau Desktop workbook. Select Dimensions and Measures and configure your visualization.Select your newly created database and the table(s) you wish to visualize (defining relationships for JOINed tables as needed).Username & Password: the credentials for a CData Connect user. Database: the virtual database you configured for the Oracle Service Cloud data.Port: the port of the MySQL endpoint for your Connect instance (default: 8006).Server: the address of your Connect instance.In the connection wizard, enter the values for your CData Connect instance and click "Sign In".Open Tableau and click "MySQL" under Connect -> To a Server.The steps below outline connecting to the virtual Oracle Service Cloud database in CData Connect and building a simple visualization from the data. Visualize Live Oracle Service Cloud Data in Tableau Desktop With the virtual database created, you are ready to connect to Oracle Service Cloud from Tableau Desktop. Click Privileges -> Add and add the new user (or an existing user) with the appropriate permissions.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |