List of Contributions

Adrian Williams

Employee

Contact Details

My Content

1 to 20 of 50+ total

RE: Using analyzeCli to migrate custom libraries

Posted By Adrian Williams 04-16-2024 12:07
Found In Egroup: Data360 Analyze \ view thread
Update: It is now necessary to include either the "--libraryNodes" or "-l" option to export (stand alone) library node(s) that may be in the source path. So the previous example of exporting a library node is now: analyzeCli --host analyze1.example.com --port 443 --protocol https export -l -f ...

RE: Full PDF Documentation

Posted By Adrian Williams 03-19-2024 12:51
Found In Egroup: Data360 Analyze \ view thread
The Data360 Analyze documentation is not available in PDF format. The Help documentation for a particular release of the product is shipped with the product (accessed using the Information ("i") button on the main menu. The Help documentation for the latest release of the product is available online ...

RE: Paging on HTTP node

Posted By Adrian Williams 03-19-2024 12:20
Found In Egroup: Data360 Analyze \ view thread
Hi Gerry, I'm glad you managed to get it to work. For the benefit of other people, Data360 Analyze ships with an example data flow that overviews the use of paging in the HTTP node. The data flow is included in the 'Data360 Samples' > 'Node Examples' directory and is named 'HTTP Integration with ...

RE: Input based Drop-Down Property for Transform Node

Posted By Adrian Williams 03-12-2024 09:52
Found In Egroup: Data360 Analyze \ view thread
The Help documentation relating to defining properties can be found in the Data360 Analyze integrated Help (See the 'Advanced Topics' -> 'Defining Properties' topic). This information is also available online for the latest version of the product here: https://help.precisely.com/r/Data360-Analyze/ ...

RE: Input based Drop-Down Property for Transform Node

Posted By Adrian Williams 03-12-2024 09:52
Found In Library: Data360 Analyze

RE: S3 Put with KMS keys

Posted By Adrian Williams 03-06-2024 05:25
Found In Egroup: Data360 Analyze \ view thread
Hi Gerry, The S3 Put node currently only supports the default encryption type. A product enhancement would be required to support different encryption types. Can you please raise an enhancement request on the Precisely Ideas page for Analyze as this will enable you to raise this with the Product ...

RE: How to import pdf documents

Posted By Adrian Williams 03-01-2024 14:20
Found In Egroup: Data360 Analyze \ view thread
The example graph is only a PoC that is intended to show how you might use the PyPDF2 module to access a PDF file. In the script in the Transform node, the filename is hardcoded - see the line that defines the 'tgtFilePath' variable. The upstream Create Data node is only being used in the example ...

RE: Someone can help-me with the sqlQuery(from field)?

Posted By Adrian Williams 02-28-2024 07:04
Found In Egroup: Data360 Analyze \ view thread
I understand there are some restrictions on how substitutions are made for items in the query that relate to the table / table metadata. I am not a SQL expert so I cannot advise on the details but you may be able to use a stored procedure/ function to implement the required functionality. I found the ...

RE: How to import pdf documents

Posted By Adrian Williams 02-28-2024 05:09
Found In Egroup: Data360 Analyze \ view thread
Importing multi-structured data from PDF files is inherently a tricky and error-prone process. PDF files may also be images rather than contain any structured data and Data360 Analyze does not include any Optical Character Recognition (OCR) capabilities. One option would be to use the Transform ...

RE: How to import pdf documents

Posted By Adrian Williams 02-28-2024 05:08
Found In Library: Data360 Analyze

RE: Calculate Fields Node

Posted By Adrian Williams 02-27-2024 12:05
Found In Egroup: Data360 Analyze \ view thread
Per the description of the node in the Help documentation: "Uses Python scripting to apply an expression to fields in data attached to the input node, generating new fields in your data to store the results of the calculation." The node was created to simplify the creation of new fields based on ...

RE: Check if property is empty?

Posted By Adrian Williams 02-27-2024 10:34
Found In Egroup: Data360 Analyze \ view thread
The example will need quotes around the property substitution to be valid, e.g. if "((^PROPERTY_NAME=BLANK^))" == "BLANK": Your solution works well but you may also want to consider using the built-in functionality ((?propertyname?)) that is described in the Advanced Substitutions section of ...

RE: Data3sixty Version Upgrade from 3.6.X to 3.12.X

Posted By Adrian Williams 01-23-2024 09:45
Found In Egroup: Data360 Analyze \ view thread
The upgrade process for the Server version of the product is detailed in the Data360 Analyze Server Installation Guide for the version you are upgrading to. You can upgrade directly from v.3.6.x to v.3.12.x as you are currently using Red Hat Enterprise Linux 7.x (Note: if you had been using RHEL ...

RE: Using Run State data in Data Flows

Posted By Adrian Williams 01-23-2024 09:12
Found In Egroup: Data360 Analyze \ view thread
Not that I am aware of in any readily available manner. The run state data for each node in a data flow is stored within the Temporary Execution Data directory that was defined for the system. You can identify the location of this programmatically within Analyze using the ls.brain.tempDir attribute. ...

RE: How to Sum 3 column value but can contain NULL

Posted By Adrian Williams 01-23-2024 07:10
Found In Egroup: Data360 Analyze \ view thread
You may also want to investigate the use of the Calculate Fields node for these types of calculations - it provides default values for different data types which simplify the processing of data containing NULL values: ------------------------------ Adrian Williams Precisely Software Inc. --- ...

RE: Cosmos DB as source

Posted By Adrian Williams 01-18-2024 08:08
Found In Egroup: Data360 Analyze \ view thread
The Vendor's information on the capabilities of the CDATA CosmosDB JDBC driver states the following for Metadata Discovery: Full support for JDBC DatabaseMetaData provides extensive schema discovery capabilities. Explore tables, columns, keys, and other data constructs based on user identity. - ...

RE: Cosmos DB as source

Posted By Adrian Williams 01-18-2024 08:05
Found In Egroup: Data360 Analyze \ view thread
I have asked my colleagues and have not found any other customers that have already integrated Analyze with Cosmos DB ------------------------------ Adrian Williams Precisely Software Inc. ------------------------------

RE: Strip characters from long string

Posted By Adrian Williams 01-17-2024 11:33
Found In Egroup: Data360 Analyze \ view thread
You can use Python Slice String in a Transform node https://www.w3schools.com/python/gloss_python_string_slice.asp For example: ------------------------------ Adrian Williams Precisely Software Inc. ------------------------------

RE: Cosmos DB as source

Posted By Adrian Williams 01-16-2024 07:06
Found In Egroup: Data360 Analyze \ view thread
A JDBC driver is available from a 3rd party vendor - CDATA - for the Azure Cosmos DB: https://www.cdata.com/drivers/cosmosdb/jdbc/ I have not tried it but it appears that the JDBC driver could be used to connect the JDBC Query node to Cosmos DB. ------------------------------ Adrian Williams Precisely ...

RE: Someone can help-me with the sqlQuery(from field)?

Posted By Adrian Williams 01-02-2024 09:15
Found In Egroup: Data360 Analyze \ view thread
Some Data360 Analyze nodes support the sourcing of certain property values from an input field. When the source for a relevant property is set to (from Field) this instructs the node to obtain the value for the property from the specified input field e.g. In the above example the value for ...