-
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…
-
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…
-
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…
-
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.…
-
Zuora Source Timeout
We are using a JDBC Driver from cData to extract data from Zuora to a Dataset, some of the tables are 20 million rows. Aperture sends the query command to Zuora which produces a download file but it can take 10 minutes by which time Aperture has fallen asleep and the data is not imported. Does anyone know if there a…
-
🛢️ Loading from OData using the Autonomous REST Connector
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…
-
401error when using AutoRest connection as external system for Zendesk API
Good Afternoon, I've created an Autonomous Rest connection and I'm able to access the tables, however when moving to the define settings step inside of the add dataset functionality, I'm getting the following error message. [ApertureDataStudio][AutoREST JDBC Driver][AutoREST]REST Status 401 Unauthorized returned for GET…
-
Connecting to Salesforce with OAuth2
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…
-
Stored Procedure invoked from PostSQL of Export step is not processing all records
hi, In my workflow, I am connecting to SQL server 2012 using Custom JDBC jar (Microsoft JDBC Jar 12.2) and the connection string looks like below…
-
Error while invoking stored procedure from Experian Aperture Data Studio using custom JDBC driver
Hi, I am using the Experian Aperture Data Studio (2.10.0.80) and have configured a custom JDBC Jar for adding Microsoft SQL Server Driver to query On premise SQL server(Microsoft SQL Server 2012 (SP4-GDR) (KB4532098) - 11.0.7493.4). With this driver, I am able to perform DML SQL queries like Select, Insert and Update.…
-
TLSv1 and TLSv1.1 protocols disabled by default in Data Studio
Towards the end of 2021, TLSv1 and TLSv1.1 protocols became disabled by default in Java 8, on which Aperture Data Studio is built. As a result, when you upgrade to a new version of Data Studio, if you are using Data Studio's packaged OpenJDK, you may find that some connections to External systems (e.g. JDBC) no longer…
-
Is anyone connecting Aperture to an Oracle 10G database please
I am looking to connect Aperture to a number of Oracle 10G databases and a number of rather old SQL Server databases. Has anyone tried this, either with the Experian JDBC drivers or with 3rd Party ones please?
-
Connecting to a SAP HANA database using Data Studio
From the Data Studio v1.6.1 release onwards, we've made it easier to connect to a SAP HANA database directly from Data Studio. With the SAP HANA JDBC connection you can load in data from HANA to Data Studio, or export back. First, you'll need to locate the SAP HANA driver. The driver (ngdbc.jar) is installed as part of the…
-
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…
