Experian Data Quality Community
-
How to export dataset through API from Aperture Data studio?
Hello All I want to export one dataset in Experian through API and save it as csv file in my one drive. Dataset exists in space which created by me, let say space name is "To_Test". In this space i enabled the "Allow publishing OData" option. I generated the API key and tested the API in swagger UI and tested on "Retrive…
-
Missing Tables in "Table or Database View" but Accessible via "Database Query
Hi community, I successfully created an external system connection to a database schema, including credentials. However, when I try to create a dataset using the "Table or Database View" option, I notice that some tables are missing from the list. Interestingly, I am able to access and query those missing tables using…
-
Guidance Needed: Transitioning Data Sources from HD Insights to Databricks
Hi Team, We are anticipating changes in our datastore architecture, which will significantly impact datasets and views currently sourced from HD Insights. These sources will need to be repointed to Databricks as part of the transition. Could you please advise on the possible solutions or best practices for handling this…
-
Salesforce tables have different columns after upgrading from Data Studio v1 to v2
If you've previously used Data Studio v1 to load data from your Salesforce instance, and have upgraded to v2, you will have noticed that the way we show column names from Salesforce tables, and the columns we display by default, has changed. This is because the JDBC driver we use internally to connect to Salesforce has…
-
Support for VARBINARY(MAX) field type in ADS
Hello I have a user case that requires migrating Salesforce objects that contain attachments such as HTML Body, PDF's, Word, Excel and jpg's attachments to another instance of Salesforce. These are normally stored as a VARBINARY(MAX) in a MS SQL database and I think would be a Blob in SQL Lite. Given these data types are…
