Hi Jan, The main issue is that OAC's API's are limited. There isn't an API for loading the data directly to OAC. I would suggest loading your data directly to a database table. If that isn't an option, I would have your script generate the file, drop the file on your client client, and kick off a script leveraging Selenium…

As far as I know, there aren't any automated ways to load data from local file storage to OAC. There aren't API's available to POST data to dataset storage. If you're looking to fully automate this process, there are 2 routes I can think of. Option 1: Update your CSV generation process to drop new data into OCI Object…

On the web application where you are attempting to embed this visualization, have you enabled non-origin sources? Typically, you'd have to enable embedding and set your Referrer Policy to allow sources outside of the web application.

This error message suggests there is a syntax error with your PL/SQL code. Without seeing the code it is difficult to give constructive feedback.

Also - check that the database user you are signing in with has 'Resource' and 'Connect' privileges

Last thing to check - did you add you Wallet contents to the OCI Client network/admin folder?

Change your server to the TNS name you want to use

Try to follow the steps outlined here: https://www.oracle.com/a/ocom/docs/database/adw-connection-instructions-tableau-desktop.pdf Otherwise, you can try to open an SR- or hire a private contractor to help get you started.

Do you have the OCI Instant Client installed?

Would need more insight to the error message you're receiving - chances are you need to configure your TNS_ADMIN environment variable.

Additionally, if you're interested in doing a full migration of your SQL Server environment to Oracle Autonomous Database, you should consider leveraging Relational Junction.

Aside from Wayne's point - as part of the Dataflow 'Save Data' object - there is an option to save to a database table...

If you type in 'BI*' then you should be fine. Oracle just has an issue with only searching '*'. Additionally, I find the UI on the Data Visualization side much easier for dealing with access.

By default no Application Roles or Users will appear. You must add a search criteria to get users/application roles to populate. Additionally, you must provide at least 1 character, you can't simply pass '*'.

Forcing user's to log back in won't update the stale data, that is going to be related to your cache. You can create an agent to clear your cache on a schedule. However, if you want to update your session settings I believe you'd do so in the IDCS instance associated with your OAC instance.

OAC has limited APIs so this process isn't native to the tool. Theoretically, you need a custom RPA solution to do this.

Depending on the data source, you can also apply the permissions at the Subject Area level. This is typically easier as it applies the permissions at a Use Case level (i.e Finance User, Procurement Users, etc)

You can apply filters against the person table to exclude these people. This can be done in the BMM layer or in the reporting layer

This is experienced by multiple users, so it isn't isolated to my personal network performance.

Is there a reason you can't use a database source? You could export csv from OSvC Load .csv to database table Create OAC Data Set with connection to the table in the database (Live connection)