-
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…
-
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…
-
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…
-
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…
-
It is possible to use the SharePoint Online list as data source?
We have a Sharepoint form with information. The form contains some columns and rows. Is it possible to collect source data with Aperture?For example. I have collected SharePoint source data with the Power BI tool. What about Aperture? Maybe in the future?
-
Issue with dates being read as American dates
I am pulling in my source data with a column that contains dates of the format dd/mm/yyyy. When annotating the columns, I have specified the column to be a date column. Now ready to explore my data, most of the dates in the column have correctly loaded in format dd/mm/yyyy. However some have converted to format dd-MMM-yyyy…
-
Document Data Lineage in my Aperture installation
I have recently joined a company using Aperture to manage their data quality. They have set up several Spaces, each of which have some of their own Datasets and some views shared from a central space. I would like to have a clear picture of all the database objects that have been referenced in datasets, views and workflows…
-
Can I Consume API in Aperture?
How can I consume API in Aperture or how can I read/parse XML or JASON in Aperture
-
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…
