Get help and keep learning and expanding your knowledge.
The Data Quality Community is a great place to collaborate, seek answers, and learn Aperture Data Studio. Register for free to join in with discussions.
Get answers to our commonly asked questions.
Get in touch with technical support.
Hi, Is it possible to connect Aperture to a SharePoint list without having the export to excel and then re-import? If it is please could someone walk me through how? Thanks!
When trying to access details of Monthly Validation Results Summary Interactive_CAIS2007, an error message appears: 6029Â - An unexpected error occurred. Please try again or contact whoever manages Data Studio in your organization. Can someone please advise, is it something I'm doing wrong? Thank you
We are trying to connect Amazon redshift database from aperture, and we are getting the below error while trying to connect. Failure com.experian.aperturedatastudio.redshift.jdbc.base.fv: [ApertureDataStudio][Redshift JDBC Driver]Error establishing socket to host and port:…
Has anybody got any experience in having Microsoft SQL Server and data tools installed on the same server as ADS is installed on which uses SQL Lite, we were wondering if they would interfere with each other?
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…
Hello, Can someone help me understand a rule and why certain criteria is listed? Rule name- The DOFD is more recent than normal on a derogatory account Why did they select those Account Statuses? For instance, Account Status 95 can be reported if an individual is not 120 late since the member is voluntarily surrendering…
Hi, I have been testing out the Rows the Column function. However, it seems to be not pulling through all the columns. In the DEV data set, I currently have 62 rows which I would like converted to columns. When using the Rows the column, it automatically only finds around 56. Wondering if anyone else has had a similar…
Hi, I'm having an issue flattening out results. Essentially, I have multiple rows for the same customer because they have different PII's. Is there any way of transforming / pivoting / flattening out the results to have one row for each customer? I have left a screenshot of mock-up data below to help people understand. I…
Hello, rookie here again. I'm trying to understand the output step but the only thing I can find in documentation is below. When do you use an Output step? Where is the output located? how do you use the output step in another workflow, view, etc.? When a re-usable Workflow is using the Output step, the step's data will be…
Hello, Our Automated Workflows have stopped working recently, and I've tracked the issue down to a broken Validate Addresses step in our cleansing workflow. As you can see "the Reference data:" option is greyed out and I cannot edit it. When I scroll over the exclamation icon the help text says "No reference data…
