-
Include Metadata in the Export step
What problem are you facing? I would like to include metadata in the export step (specifically in the JDBC option) that includes metadata for the target system and table (e.g. tablename, DBMS system, credentials used etc.) as this would help users / DBAs to debug/resolve any issues or be included in a point-in-time audit…
-
Delimited csv file creation using Export step
Hi, We are using Experian Aperture Data Studio version 2.14.14.40 and have changed the settings to accept csv delimiter to pipe (|) But there is a requirement to delimit csv files based on runtime configurations. Is there a way to define the delimiter in the export step while writing datasets as csv likely from a parameter?
-
Adding gzip Compression Method
What problem are you facing? gzip(.gz) compression method option not available when adding of compressed datasets and in the export step for compress or compress and encrypt. What impact does this problem have on you/your business? Most internal and clients files are compressed using .gz. This is has been the case for…
-
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…
-
Snowflake Export
Hi Everyone, We just upgraded to the latest version (2.13.2.35) but have been having trouble exporting to snowflake. It just gets stuck and the jobs don't even cancel. I am working with support also but checking to see if anyone has successfully been able to do so? I had issues prior to the upgrade as well. Regards, Sumit
-
Export in differents folder
Hello dear community, Is it possible to export (the result of a workflow) in different folders or sub-folders, in other words, workflows of the same space exporting in differents folders or sub folders Because today (my version is 2.8.8) allows my to export only in my space export folder: \Export\Production\space1…
-
Is it possible to export a file as an XML please?
I have a set of data and would like to be able to export it as an XML. I have a solution that allows me to export a set of records surrounded by XML tags and prefixed by a sort key. The different sets of records are exported into a directory and the solution then ingests these, sorts them according to the key, strips off…
-
Can we add a hyperlink to the e-mail notification?
Hi! Is it possible to add a hyperlink to the e-mail notification? It would be a nice feature to be able to add a URL or a direct link to the export folder where the exported files are located. Many thanks! Vera
-
Workflow - Export to Dataset, then Refresh
We have a workflow that is compiling some results from several steps (into a union), and then exporting to a JDBC external system with a defined dataset. As a last step, we have linked the export to the source of the defined dataset assuming that once it has exported the data, it would refresh the dataset, and we could see…
-
Read from one space, write to another
Forgive me if this question is easy to answer; still getting up to speed after implementing Aperture Data Studio earlier this year. So I have some rather large datasets that come from our data warehouse. There are different use cases that require reading data from these and writing to someplace (JDBC database, Snapshot,…
