The CData Power BI Connector for Oracle Sales Cloud models the Oracle Sales Cloud objects as relational tables. Tables support both retrieving and updating data.

You can work with all the tables in your account. The connector connects to Oracle Sales Cloud and gets the list of tables and the metadata for the tables by calling the appropriate Web services. Any changes you make to your Oracle Sales Cloud account, such as adding a new table, adding new columns, or changing the data type of a column, will immediately be reflected when you use the connector to connect.

Tables

Oracle Sales Cloud objects have relationships to other objects; in the tables, these relationships are expressed through foreign keys. Oracle Sales Cloud objects are also part of an application that the account contains. For example, the table Opportunities represents the Opportunity object, which is part of the Sales application.