Get useful advice from our experts
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.
The Autonomous REST Connector JDBC driver packaged with Aperture allows you to load (and refresh) the results returned from REST API calls as Datasets. OData is a standardized REST interface, which means that any data that can be queried via OData API can be loaded into Aperture. This article will demonstrate how to useā¦
In this video I will show how different types of user role and license assignments have different abilities within Data Studio. I will show one way that I might share a particular view of the data to 'consumer users' that they can look at and explore but cannot save or manipulate beyond data exploration.
Data Studio uses a JDBC driver to connect to Salesforce, allowing data to be extracted, transformed, validated, and then optionally pushed back to source. As well as standard username / password authentication, the driver supports OAuth 2.0 authentication when establishing a connection. The following guide is a briefā¦
If you are looking to use a value in your data as the export file name, you may have looked at the Export step and realized that it does not allow you to directly select a value from your data as a filename component. However, you can actually use a workflow parameter as a filename component to achieve this. You will haveā¦
Aperture is a powerful tool when validating business information you already have. We can leverage trusted address sources, like the Royal Mailās Postal Address File, for the UK. This will ensure that the addresses and business name information you hold is accurate and deliverable as per that trusted source. Thatās allā¦
Imagine you are asked to use Aperture Data Studio to generate a new field for your sales data. You have the input fields: Discount Code, Quantity and Price. The ask is to generate a new field āOffer Priceā using the following logic: How can you do this in Aperture Data Studio? The answer is to build a custom transformationā¦
A question that cropped up earlier today was: 'how can we avoid different users connecting to the same data in different spaces?' Depending on how you've setup Data Studio and the processes around how your users work with it, this can be a bit of a challenge to tackle at the moment. However there's a solution, which isā¦
In this article I want to share a few approaches to configuring paging when accessing REST APIs using Aperture Data Studio's Autonomous REST (AutoREST) connector. What is the AutoREST connector? If you're reading this, you're probably already familiar with the AutoREST connector, but in case you're new to it, check out:ā¦
Assuming Data Studio is set up and your user account has been created, āYour spaceā is your personal work area. Any changes you make in this Space will not impact any other users. To understand some Aperture Data Studio specific terms (highlighted in bold below) the documentation site is a useful resource. Other resourcesā¦
Data Studioās Dynamics 365 connector can be used to read or write data from Microsoft Dynamics 365 apps. Click for a full list of supported Dynamics 365 ERP and CRM apps by the driver Click for a the driver's user documentation Click for basic config and troubleshooting steps in the Data Studio documentation The driverā¦
This will be a special User Group event for us as we have an opportunity to share a real milestone in our product innovation.Ā Our ānewā Aperture Data Studio is ready, and weād love to have the opportunity to celebrate the enhanced capabilities together! We know you love data ā by coming along you can exchange with yourā¦