You are here:
OSI Workflow
The OSI workflow uses open-source translators and customer-managed infrastructure.
Before importing an OSI model into Tableau Semantics, make sure that these requirements are met.
- The underlying data exists in Data360 (either ingested directly or accessed via zero-copy architecture).
- Object and field names in Data360 exactly align with the definitions referenced in your OSI file.
Import a third party semantic model using OSI
The workflow includes these steps:
-
Export your existing model to the OSI format.
How you translate your model into the OSI format depends on where your model exists now (Snowflake, dbt, and so on). While each vendor may provide different tooling for the translation, all published translators can be found in theOSI GitHub repository. The outcome of this step is a portable semantic model in the OSI format.
-
Add required metadata to the OSI file
Some metadata is not yet fully standardized in OSI v0.1 and must be manually added to the OSI file through custom extensions. Update your OSI file using the below properties to match your Data360 configuration:
- Data set source: Update the source value for each data set to match the object API name of the corresponding data object in Data 360.
- Data space: Provide the relevant data space API name.
Example:
"data": "{\"dataspace\": \"default\"}" - Object type (DLO or DMO): For each dataset in OSI, specify whether the object is a DLO or
DMO in Data 360.
Example:
"data": "{\"dataObjectType\": \"DMO\"}" - Field type metadata: For each field, add the field data type that matches the field type
in Data 360.
Example:
"data": "{\"dataType\": \"Text\"}"
-
Translate your OSI model into JSON compatible with Tableau Semantics
Now that you have an OSI file with all the necessary metadata, run the OSI-to-Salesforce translator (via CLI or custom code). This produces a semantic model json file.that Tableau Semantics can consume.
-
Import your semantic model into Tableau Semantics
Use Tableau Connect APIs to port the translated semantic model in your Tableau Semantics environment. SeeTableau Semantics Layer APIs for more information. This creates the final asset that Tableau Next and Agentforce can consume.
After the model is available in Tableau Semantics, you can query and use the model the same way you use other Tableau semantic models.
