Data360 DQ+

Hello Team,

Good day!

Telstra’s IFRS15 revenue reporting solution is implemented using Data3Sixty. We had 6+ major release & production defect fixes deployments happening across environments on a daily basis. All deployment activities are managed manually as we don’t have the capability of an automated deployment. So I need your support on the following questions to address the problem statement.

Question 1 : Is there any tool that can be integrated with Data3Sixty 2.1.2 for automated deployment?

Question 2 : If there are no tools that can be integrated, can we do the deployment from the backend using command line, if yes please provide the command line options/documentations ?

Question 3 : If the above 2 can’t be done, what version of Data3Sixty will support the integration with the automated deployment tools?

Version : Data3Sixty 2.1.2

Current versions of DQ+ have REST APIs that can create / update data stores and perform executions (more details here: https://support.infogix.com/hc/en-us/articles/360025651514-Using-Data3Sixty-DQ-s-REST-APIs ). However, this isn't a full automation since not all types of items can be imported via the REST API.

Starting in DQ+ 4.0, we are beginning the switch from REST API to GraphiQL API. This feature is available in v4.0 as a "tech preview" since the full functionality is still being built. The current capabilities of these new APIs can be found in the v4.0 release notes: https://support.infogix.com/hc/en-us/articles/360036278114-Data3Sixty-DQ-4-0-October-2019

My understanding : 

• The current version (2.1.2) can't integrate with 3rd party tools for deployment nor can deploy code via command lines.
• Version 4.0 will have a new API (GraphiQL API) that will enable us to integrate with other systems and additionally can create data stores, create data views, and read, create, update and delete environments. 

I am looking for specific answers to the below question.

• Does the new API that comes as part of version 4.0 will have the capability to create/update analysis, create/update process models, can read the export file from a lower environment and import it in the current environment?
• Can it be integrated with Jenkins for automated code deployment?

1. No, the v4.0 APIs will not have this functionality since all aspects of the APIs are still being built for future releases.

2. Does Jenkins support connecting with API endpoints? if so, the you'll be able to connect to our APIs with it.

Hi Brenda & Team,
Can we have an enhancement/patch on the current D3S version (2.1.2) to enable the automated deployed using standard deployment tools like Jenkins? Or alternatively, a patch that will enable us to deploy the code on the command line.

We are looking for the code/script that the "Import button" uses so that we can automate our deployment activities using it.

Hi...

We currently do not have any API available for DQ+ 2.1.2 that allows such functionality for automated deployment. Unfortunately, due to the complexities of such requirements, we would not be possible to implement such functionality in an earlier release.

Planned in DQ+ 4.3 (available end of March), there will be a new GraphQL API which is based on HTTP that allows export/import to be performed through API. Not being as familiar with Jenkins, I am not sure if the import will work with it and DQ+. Import should work with any client tool that supports integration with HTTP APIs that require multipart file upload. Support for http multipart file upload is needed for definition zip files to be upload to the import API.