-
Sneak peak of new data quality offering: Let us know what you think
Hi everyone, In this post I'd like to provide you all with a sneak peak of a new real-time data quality enforcement offering that we're currently exploring, that we'd love to get your feedback on (complementing our existing contact data validation products). The idea centres around exposing Data Studio functionality (e.g.…
-
Customizing your Dashboard with the Custom content widget
Data Studio Dashboards can be configured by adding, ordering and resizing different widgets including Views and Charts. One of these widgets is the Custom content widget: Firstly drag the Custom content widget onto your Dashboard. Next add some text that your colleagues will find useful: Add style 🕶 To make this…
-
Connecting to an Amazon RDS MySQL Database
A user recently asked about connecting Data Studio to their AWS RDS MySQL Database. The first thing to note is that MySQL on RDS uses the MySQL community edition, which is not supported by Data Studio's native JDBC driver. When attempting to connect, you'll receive this error: "Connections to MySQL Community Server are not…
-
đź”” Follow what you're interested in
When you navigate into any of our categories you will see a Follow button in the sidebar. This will allow you to subscribe to getting email notifications and notifications in the community about that topic. So for example if you want to be notified of new releases, navigate to the release and downloads section and click…
-
Native Function: Is Web URL
Hi, I am using the above function and the result for checking this site "www.californianotary.academy" comes back as bad, even though it can be accessed in a browser. Does that function expect something like ".com" rather than ".academy"?
-
Update Issues once Resolved?
Hi, is it possible to update an issue once it has moved to 'Resolved'? For example, a set of data gets manually updated, and after resolution we want to reflect that via the 'External ID' (e.g. a ticket number). Thanks
-
Adding an Owner to my business rules
Submitted on behalf of a customer. We have created many different validation rules to monitor the quality of different datasets over time. It would be useful to denote who is the owner of a specific rule in case changes need to be made in future.
-
Automated date in output
I wonder if there is any way of setting up in an automation the Take Snapshot step with the date information on it. Like for example: ADSExtrac_20241113.csv
-
Suggested approaches for manipulating JSON values
My data includes a column containing JSON values - I've made a dummy example below: Example JSON value: { "magenta": "#f0f", "yellow": "#ff0", "black": "#000", "usageList": [ "giraffe", "lion", "axolotl" ], "properties": { "cost": 99, "difficulty": { "part_a": "hard", "part_b": "easy" } } } I have a couple of requirements:…
-
Is it Possible Integration with with NETCONF Protocol ?
Can Aperture Data Studio integrate with device configuration system with NETCONF Protocol
-
Sorting an Issue list results in fewer rows
hi, So I have a workflow that I use an 'Issue list' as my source - the issue list has 29 rows. If I add a step to sort on the 'Failed Rows' column, my output for that is now 22 rows. No other filtering going on. Tried it on 2 different issues with the same result. However, if I remove the sort on the 'Failed Rows' column I…
-
Looping workflows
About the requirement Recently I’ve been asked a couple of times if it’s possible to cycle through a workflow for every value within a given column. This is mainly to drive 2x types of use case: Dynamic data export – effectively taking an input dataset and splitting it out into a separate file for each subset of data (as…
-
Adding Microsoft SQL Server to an ADS server
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?
-
Aperture REST API calls as Datasets within Aperture
Data is available from Aperture via the REST API that is not available in Aperture. Full details of Spaces, User Groups, Users, Jobs, Datasets etc. We would like to use Aperture to manage Aperture. For example: An automated workflow which checks for long running jobs and notifies us of issues; a regular review of user…
-
Is it possible to configure which events are included in the audit report?
There would be a need to get some more events included in the audit report, is that possible to be configured by the administrator?
-
Your API key < API key name > will expire in 10 days'
can u help me set up this? i cannot find the right directives in below documentation. i need to know via email, before api keys expire. Br, HS i want to know before hand, @Henry Simms @Ian Hayden , @Josh Boxer https://docs.experianaperture.io/data-quality/aperture-data-studio-v2/monitor-data-and-troubleshoot/
-
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…
-
Best approach for this set-up?
Hi, Any recommendations for this configuration? Lets say I have a space called 'PROD-DQR' that is used to access production data with a read-only credential to the source DB. It validates data, sends to issues etc. Only DBAs are allowed to perform updates in production, so was thinking: New spaced called 'PROD-UPDATE' that…
-
Rule Question (DataArc360)
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…
-
How to resolve "No space left on device" errors
Hello, In the last few days we have been encountering the "An unexpected error has occurred during Workflow execution: 9003: An unexpected error has occurred during Workflow execution. No space left on device" error. We have gone through our installation and removed a lot of datasets that we no longer need which should…
-
Exporting to External System using JDBC
Waiting to get an external system set up to allow updates via JDBC - in the meantime, if I select mode = UPDATE in the export step, does a full SQL statement get generated (to allow our DBAs to verify and QA the process). Thanks
-
Dynamic Reports in workflow - if x then do, if y then do something else
Hi all I'm new to Aperture and have just built a report in a workflow. It looks good and I am happy with the tables that I have pulled through. My report shows a summary of all of the checks and then I have an individual table showing the failing rows for each of the rules. Of course, sometimes, I have a rule that doesn't…
-
Data Studio Salesforce Connection
Connecting Data Studio directly to your data sources and CRM systems, like Salesforce, has never been easier. This video is to remind and inform users, just how easily two systems can work in harmony, without any complex development. We've created out of the box connectors, for a wide range of common platforms, to make…
-
Annotate Columns
Hi, is there a quick/easy way to mass update when performing 'Annotate columns'? I want to add tags not based on the data contents, but on security definitions. E.g. Some columns could be PUBLIC, some could be CONFIDENTIAL. Thanks
-
Experian Aperture Data Studio Report View
Hello. new to the tools trying to figure things out. Making progress, I've created several workflows successfully, and created datasets using snapshot, and used those datasets in other workflows and views. My question concerns Report View In Workflows. I've found very little documentation on this. I added a Report to the…
-
Data Studio certified to run on Azure Stack HCL or Nutanix?
Is Experian Data Studio application certified to run on Azure Stack HCI (Azure's version of VMware) and/or Nutanix?
-
Unable to connect Find dupliactes on new server
Hi team, We have recently installed the aperture Data studio application recently on our new pre-production server and we are unable to connect find duplicate server due to the below error. Please help us to this issue 2024-11-04 00:05:32 205 WARN c.e.d.m.MatchServiceManager [MatchLicenseMonitor] Unable to connect to Find…
-
Do you have a need for Pivot/Unpivot steps?
As part of our product discovery activities, we would like to find out if any of our clients have a use case for pivoting or unpivoting data. If you do, we'd like to hear about it. Please leave us a message and we'll get in touch.
-
OAuth 2.0 authentication method with Snowflake
What problem are you facing? How can we connect to Snowflake external system with OAuth 2.0 authentication method? What impact does this problem have on you/your business? We cannot develop new functionalities. Do you have any existing workarounds? If so, please describe those. We can connect through a user ID / password…
-
UX improvement - connecting Workflow steps
Submitting on behalf of a user: What problem are you facing? Sometimes it can be a bit tricky connecting two workflow steps that have ended up far apart. What impact does this problem have on you/your business? It's a bit fiddly and slightly more time consuming. Do you have any existing workarounds? If so, please describe…
-
Fuzzy Matching Logic
Hi, I have a requirement to match records from two separate systems on the basis of FirstName, LastName and DOB from System1 and FisrtName, MiddleName, LastName and DOB from System2 to return the match Id from System2 to System1. Below are the challenges The names are not consistent in both systems . For eg in system1 for…
-
Export Data Object to external systems
Submitting on behalf of a client: What problem are you facing? Cannot export the new data objects to external systems, re-work of re-tagging is time consuming. What impact does this problem have on you/your business? Time consuming and need to match the object tags back to the relevant CDE's Do you have any existing…
-
Validate address data dictionary?
Hi, started looking at 'Validate Address' step and cannot find a data dictionary for the returned fields. For example, AddressAction I see 0 & 3 and Street Non-trivially Corrected I see blanks, 0, 1. Any pointers would be great, thanks
-
Automations and notifications.
if I want to trigger automation if any workflow failed in that space. is that true for that case as well. I was going through some documentation. Data Quality user documentation | Automations and notifications so here i would want the same for workflow failure. any workflow fails in that space, i want the event to trigger…
-
Any Function to check the one field in Present in the List of the fields?
For example I have a column where I have Value like this If I use function contains then I am getting this true for all of the above scenario, but I want only row 1 should be true and rest should be false when the entire string is not matching. Can this be done?
-
Turn a field storing a list into rows?
Hi, is it possible to turn a list stored in a column into rows? For example: ID COL 1 AA,BB,CC 2 XX,YY,ZZ Becomes 1 AA 1 BB 1 CC 2 XX 2 YY 2 ZZ Thanks
-
Unable to restart the Aperture services
Hi team, Suddenly the aperture data studio application is connecting. We tried to restart the services and the services are still stopping .we are unable to restart the services. Can you please help us to resolve this issue ASAP .
-
Dropzone
Hi there, How do add columns on a dropzone file? The columns have been added in the source file but it's not reflecting on the dropzone file in aperture. How do I fix this? I have tried adding a new external system but it doesn't work. Many thanks, Mariana
-
Network error
I am trying to create a development environment to test some changes but when I try to import anything to it, gives me this network error message. Any ideas on what the problem is? I am connected with the VPN, already checked that! TIA, Mariana
-
Best practice for checking that Datasets have been refreshed
A user asked this question: We have hundreds of datasets we need to refresh before a migration, what is the best practice in ADS to make sure they have all been updated, without adding a source in a workflow for every dataset can you iterate through the desired datasets and look at the metadata to determine when it was…
-
What's the syntax for the Dataset "file pattern" text when loading from an SFTP dropzone?
I'm setting up a Dataset that automatically refreshes with data from files dropped into an External System dropzone (SFTP in this case). I only want to load specific files, determined by the file name. To do this, I was going to use the "Starts with file pattern" config option, but I couldn't find any information about the…
-
Prevent object tags from requiring a workflow to be re-published
What problem are you facing? I have applied the new Object Tags to various workflows. In each case the workflow status changed from Published to Draft when the Object Tag was saved. The tags can be bulk added but the workflows must then all be individually re-published and a comment added. What impact does this problem…
-
Application Theme?
Hi, Is there any config that can be changed to tweak the appearance of an environment to help differentiate between a development and production build. For example, I was thinking something along the lines of being able to select a different colour for the left menu or top bar may offer an obvious visual reminder. Thanks…
-
Where I can change Backup period start time?
Hi all, I found place where I can set backup time period. But nowhere are no mention how to determine exact start time of that period. So, our case I want that backups are made ones per day and time should be around 22.00 or near. This time is important because our server backups are running over a night. Now, it seems…
-
Inquiry Regarding Royal Mail Address Database Updates
Good afternoon, We are currently using the "Validate Addresses" step to check UPRNs. However, we have observed a significant number of addresses—where we already know the UPRN—that are returning empty during validation. Could you please confirm how frequently the Royal Mail address database is refreshed? Thank you for your…
-
find duplicate update row limitation
Is currently is there any limitation in the latest version ? I am getting error in my existing workflow . Please suggest where I need to change to set the limit
-
DDL for datasets before including in aperture.
Hi, Is it possible to see DDL of tables before adding those in datasets from external system? or Aperture does not have that kind of control. can i see DDL of tables before adding? or service_account wont have that control.? Br, HS @Ian Hayden , @Henry Simms
-
All Schedules information?
Hi, I'm looking for a way to be able to view details of all the Schedules that exist within our environment. I'm thinking details like space, schedule name, recurrence pattern and workflows ran by it. Is there a way to surface this information via API or otherwise? Thanks Mike
-
swagger UI for find-duplicates- error. after recent upgrade.
Hi, We are seeing this error after the latest upgrade. Upgrade done on our dev is as under.Upgraded to Aperture Data Studio to version 2.15.4 and Find Duplicates Service to version 3.11.3 @Ian Hayden , @Henry Simms , Kindly help and let us know what this is about. Services are UP, but we usually dont see this error when we…
-
unable to connect Aperture application
Hi Team Since yesterday, we were unable to connect Experian Dev server application due to the below issue. 2024-08-20 10:26:03,880 INFO c.e.o.o.CLITool [main] Executing '"C:\Program Files\Experian\Aperture Data Studio 2.14.10\oaserver\runtime\windows\64\admin\oacla" -nologo -dbg -d "C:\Program Files\Experian\Aperture Data…
-
Drop-down picklist instead of free text entry for re-usable workflows
What problem are you facing? Currently re-usable workflows allow a free text input option, which suggests most recent entries. The value entered will be used in processing within the workflow, often relating to fields/data to use for matching etc. This leaves risk of error, if the user enters a typo, which could result in…
-
Different date formats not being recognized as a date
What problem are you facing? Because the data is coming from many different sources the dates have different formats and when they are mixed up in one input it gets difficult to put them in the same format as they are not recognized as date datatype, so I would love to be able to just use the format date function and fix…
-
Workbench
Hi everyone, I am trying to analyse some blocking keys on the workbench but it keeps on this page forever. Is anyone else going through the same issue?
-
Importing data into Salesforce child objects
I have a user case to use out of the box functionality that come with Salesforce and is available in the Progress Driver to relate data in parent and child objects on import. In a Salesforce object you can designate a field as an external ID. When you load a child object such as Contact where the parent is Account and you…
-
Issue list - see comments?
Hi, is there a way to see all the comments that have been added to an issue list? Also, can comments only be updated manually? Thanks
-
Aperture Data Studio service suddenly stop
Hi admin, i have aperture data studio ver 1.5 server and license exp on 13 feb 2025 , the problem is when server date is actual date/current date, the service running about 1 minute and stop suddenly. for example if today is 5 oct 2024 and date server is same the service stop, and if date server changed to 25 oct 2024 the…
-
Security related Documentation
Is there any documentation available where it tells about how secure is Aperture in terms of handling the data. We might need to provide this document to one of our internal team as we try to access that source system's data through aperture
-
Split a value into multiple rows
Hi I have full addresses split by ; that I want to split out into new rows ready for the Address Validate step. An example of the data layout ... "Address1 Address2 Address3 Town County Postcode;Address1 Address2 Address3 Town County Postcode" This should become two rows "Address1 Address2 Address3 Town County Postcode"…
-
Ability to select specific last number of batches in charts
What problem are you facing? For charts, if I only want to list the last N batches, I have to create a whole new process to create a new dataset. What impact does this problem have on you/your business? Extra maintenance and resources Do you have any existing workarounds? If so, please describe those. Use workflow to…
-
Charts - last 10 batches
Hi, if i wanted to create a chart that graphs data quality over time, but I only wanted to display the latest 10 batches from a dataset, what are my options for this? I was thinking that a workflow would use the original file as a source, and I would specify 10 batches, and that would output to a dataset (single batch…
-
Add Source to Column Names
Is there a way to bulk update/set an option to add the Source name to all columns, rather than just the _1 on the second source? For example, if Source1 and Source2 both have an ID column, then columns would be named Source1.ID and Source2.ID, rather than ID and ID_1 which is ambiguous outside of the workflow.
-
 ℹ️  Importing your Datasets into Excel or Tableau using OData
You can easily get your data from Data Studio into Excel or Tableau using OData. OData (odata.org) is “an open protocol that allows the consumption of data via a simple and standard RESTful API”. If you choose to turn on OData in Data Studio (v2.2.3), you will be able to link your datasets (including snapshots) to any BI…
-
đź“Ł Join us at our next User Group - 12th November 2024
We would love you to join us for our next Data Management User Group taking place on 12 November 2024 between 10:00am – 3:00pm at our offices in Cardinal Place, Victoria, London. Join us for a day of networking, in person to hear from industry experts about what’s happening in the world of Data, AI along with real-life…
-
Date format
Hi there, I am having trouble with some date data. ADS is not recognizing the dates that comes from Azure Data Lake. Is that anyway to change that?
-
đź“Š New chart types
With an increasing number of users now spending more and more time building (and then interacting with) charts and dashboards, there are a couple of additional requests I'm hearing cropping up relating to this so I'm posting them on here for discussion and to get the wider Community's thoughts. They are: Adding some new…
-
Invoking PowerShell script from Experian workflow/Schedule
Is there a way to invoke a PowerShell script from Experian Aperture Data studio using workflow or schedule? I am using the 2.14.14 version
-
Ingest data with API, check rules, send results back to source system
A Data Studio user raised the following questions: Is there any demo or material to show how can we configure Aperture ingest the json data with api service and check the data quality rules and response it back to the calling system again ?Â
-
Use REST APIs to automate processes
Data Studio now has over 100 REST APIs that allow information to be extracted or actions taken programmatically allowing processes run automatically with little intervention. APIs also enable integration with third party applications to make Aperture part of your broader business operations. Besides the additional APIs…
-
Rows to Columns
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…
-
Flattening out / Pivoting / Transforming results
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…
-
Include Chart in notification?
Hi, is it possible to include a chart in a notification? Lets say I want to show progress on some cleansing over time, and the chart is sent at the end. Thanks
-
Compare Dates (Verbose) đź“…đź“…
Compare Dates (Verbose) [Category: Conversion] This function provides a summary of how 2x input dates compare (and also includes simple 'convert to date' logic to aid the analysis). Output options are: Exact match Incomplete - Date 1 is missing (or not a date) Incomplete - Date 2 is missing (or not a date) Incomplete -…
-
REST API workflow Execution Error
hi, I have created a reusable workflow accepting 4 parameters with source configured as below "sources": [ { "stepExternalLabel": null, "canSupplySourceWhenExecuted": true, "mustBeSupplied": true, "allowAutoRefreshed": true } ] I am trying to execute the workflow using below request, but I am getting error for the…
-
Experian REST API for Dataset Creation
Hi, Can someone please help me with the JSON request to create a dataset using SQL query? Below are my dataset requirements a. Type : JDBC(SQL Server 6.0) b. Allow Refresh : True c. AllowBatchDeletion : False
-
Experian API call to Execute Workflow
hi, Can someone help me with the JSON request to invoke a workflow through REST API? Below are my workflow specification a. Workflow accepts workflow parameters b Workflow accepts source at execution and its mandatory to give source information.
-
How to capture log errors into a table if error occurred during execution of workflow or Schedules?
How to capture log errors into a table if error occurred during execution of workflow or Schedules
-
Aperature Data Studio Elearning
Hello how do you request access to the elearning? is there a cost? We are planning to use the product to maximum degree possible. this could come in handy in our learning process, especially if it includes videos/samples for the functions within. 403 App Not Assigned Sorry, you can't access Docebo-Production because you…
-
OUTPUT step in a workflow
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…
-
â„ą How to use Functions in Workflows
Workflows Workflows is the area in Data Studio where designer users tend to spend most of their time. For anyone new to it, imagine a data pipeline that manipulates one or more data sources through a number of stages and then does something with the results. Whilst a Workflow is easy to build by connecting different steps…
-
đź“Ł Join us at our next User Group - 9th November 2023 đź“…
I am pleased to confirm that our next User Group event for Aperture Data Studio users will take place on Thursday 9th November, 11am-3pm (UK-time). We will be running the event from our offices in London (near Victoria statioon) but will have a dial-in option for those who are unable to be there in person. Following on…
-
COMING SOON: Webinars
Subscribe to be the first to find out!
-
Error while invoking REST API from Experian Studio VM
Background Experian data Studio version - 2.14.14 SSL setup done on the data studio url and private CA is added to the trust store under E:\ApertureDataStudio\certificates\cacerts API Key genrerated with 365 days validity and able to invoke API via Swagger Issue While trying to invoke the CURL command from command prompt…
-
Having an issue managing too many objects
Submitted on behalf of a customer. Multiple active users collaborating in a Space have created many Workflows and Views etc. It is becoming difficult to quickly find the specific item that you are looking for sometimes needing to go in and out of a few things before finding the correct item. It would be good if the…
-
More detailed manuals/examples/syntax
Hello. I'm new to Experian Aperture Data Studio V2. I'm using the documents/help at the Data Quality User documentation site. I'll give you an example. I'm trying to use Get age to filter a dataset down to records with an effective date (one of our fields) to only the current year. The Get age tells me "Returns the number…
-
Accessing Azure KeyVault
I have stored my Azure SQL's connection string as a secret in the Azure KeyVault. I wanted to access this secret value while trying to create an External System.
-
♻ Reusable workflow example – calculate word frequency
Today I’d like to share with you a reusable workflow that I built a little while ago not only as a downloadable .dmx file (see below) for you to explore/use as you wish, but also as a means of demonstrating one of the key themes of Data Studio…reusability. If you find that there are duplicate tasks being executed on your…
-
Experian Aperture Data Studio REST API error
Hi, I am planning to automate dataset creation using Data studio REST API, however I am getting 401 Authorization Error. Background Experian data Studio version - 2.14.14 SSL setup done on the data studio url and private CA is added to the trust store under E:\ApertureDataStudio\certificates\cacerts Please see the steps…
-
Manually reviewing clusters of duplicate records
What problem are you facing? As a Find duplicates user I want to be able to manually evaluate and change clusters of records where I think the rules have matched records incorrectly e.g. I've got a husband and wife in my data, both called M. Smith and they share the same postal address, email address and loyalty card…
-
Re-run Track Issue list?
Hi. I have a workflow that validates a file and sends failing rows to an Issue list. I have made that workflow reusable and can supply source when executed. I have another workflow that uses the same source data, but does some transformation to correct data anomalies. The final step in that workflow is to execute the first…
-
Another Dataset already exists with external label
A Data Studio user had the following challenge/question that might be relevant for other community members. I'm getting the above error ('Another Dataset already exists with external label') when trying to synchronize a dataset into an environment. I found the dataset in question and deleted it from that space where it's…
-
AWS S3 Dropzone
A Data Studio user had the following question that might be relevant for the community. Is someone able to elaborate on how an Aperture dropzone on an AWS s3 bucket works? I have a dataset setup as a dropzone and it correctly picks up new files of a different name when added to the s3. However, if I replace a file with a…
-
Solution Deployment error
This question was raised by a user and might be relevant to other community members. What can I do to resolve a Solution Deployment error? BTW I also have a "Data Discovery Pipeline" space in this destination environment, also with the same external label but this one doesn't get rejected ... Could it be because object…
-
Automation Time Expiry Limits
A Data Studio user had the following question that might be relevant for the community. I have a monthly job that has data coming from multiple datasets across the month. What is the maximum time period (minutes) allowed for an automation and does that limit get reset for any reason i.e. a server/application restart?
-
How to best keep several environments in sync
I'd like to share a question that was recently raised by a user as I think it could be interesting for our community members. Question: We have two physical environments - Dev and Prod VMs and we have promoted all the objects from Dev to Prod environment (Export and Synchronised). Over time, Dev has gone through several…
-
Export CSV to Azure Data Lake
I'd like to export the CSV files from Experian to Azure Data Lake Gen2 (ADLS) storage account. What are the pre-requisites for establishing this connectivity? The studio tool is installed on the Azure VM.
-
Sticky Notes attached to Workflow step
Just a thought… but it would be really nice if Sticky notes could be pinned to workflow steps (I always provide decisions or descriptions of steps as part of knowledge transfer). That way if I move my workflow step the Sticky note comment moves with it (or worse, someone hits the auto-arrange button and now my Sticky notes…
-
Connecting to the ServiceNow REST API using OAuth2
The Autonomous REST Connector JDBC driver allows you to load (and refresh) the results returned from REST API calls as Data Studio Datasets, by translating SQL statements to REST API requests. In this article I'll show how to call ServiceNow's REST API (using OAuth2 authentication) to bring response data into Data Studio.…
-
This site can’t provide a secure connection
Hi team, I have applied the SSL certificates with wrong private key file on our aperture server .The aperture application is not connecting due to the incorrect private key. Could you please help me to remove the applied SSL and reapply again.
-
Change my profile email?
Hi, this account email I use is from one one my clients, but I am about to start another contract with another client (that uses Aperture). So I want to change my email address from the customer domain to my own company domain so that I am more neutral. Is this possible? Thanks
-
Exporting - Extension Missing?
Hi, just upgraded to version 2.14.12.195 and noticed something in the 'Export' step. If I export to CSV, Excel etc. and my file name is split with a full stop, the extension is suppressed. For example file name "FILEOUTPUT" gives me" FILEOUTPUT.XLSX" but "FILE.OUTPUT" does not add the .XLSX extension. I noticed because…
-
How do I select a reference data to use in Validate Addresses?
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…
-
Problem updating Server Certificate
Our tech team previously applied a cert to the server a couple of weeks ago, now we are looking to upload the Server Certificate but have come across a problem in uploading: We used the same cert file due the documentation stating: For certificate files which include both certificate and private key, such as .pfx, the same…
-
No JDBC option for external system
Hi, any reason why I would not have a JDBC option in the drop down for creating an external system?
-
Automations - License Expiring Event
We have been unable to trigger the License Expiring Event for 'License Days Remaining Less than 365' with a Notification to users. License Expiration is Aug 2, 2025. What needs to happen to trigger this event? We've had a dataset load, complete workflow and waited overnight. We were only able to generate an notification…