No-code integration with high-speed Big data analysis cloud
20211011-PR-en-v132-google-bigquery.pdf
Kyoto, Japan, Oct. 11th, 2021, Questetra, Inc., the global SaaS provider of Business Process Management (BPM), today announced that they have published the new version 13.2 of the Cloud-based Workflow product Questetra BPM Suite. This new version 13.2, will allow you to build a mechanism to automatically add business data to Google BigQuery tables using only standard features.
Google BigQuery is a cloud service that stores big data and is capable of analyzing it at high speed. For example, Google BigQuery analyzes homepage access logs, order data, etc. at high speed, and the results will be used to predict order trends or to create daily reports. As Google BigQuery is also used by large companies such as UPS, Inc., Twitter, Inc., and Toyota, many companies are working on the use of big data.
Starting with the new version 13.2, Business Processes will incorporate the ability to add data to Google BigQuery tables. You will be able to build a mechanism that is, for example, in the Order Fulfillment Process on an e-commerce site, data such as customer name, order details, order date and time, shipment time can be automatically added to the orders record table of Google BigQuery after the shipping process is processed. You can achieve this just by making configurations, and no coding is necessary.
Questetra BPM Suite
Cloud-based Workflow Questetra BPM Suite is a business platform for realizing paperless environments and remote-working. Business issues are controlled according to a Business Flow Diagram. When a Process reaches a Human Task the user will be asked to add their input. Also, when an issue reaches an automated Step the predetermined processing (server-side processing) such as generating a PDF and saving it to cloud storage is performed automatically. (BPM: Business Process Management))
You can apply it to various business operations such as an Approval request flow, Document translation flow, Quality check process, and Invoice issuance process. Process owners of each Business Process can practice the Improvement of Business Processes little by little in daily work. (Examples of Business Flow Diagrams: https://questetra.zendesk.com/hc/en-us/articles/360012492211 )
Google BigQuery: Insert New Data
You will be able to use this item to automatically add data to Google BigQuery tables. This allows you to build a mechanism, for example, so that order data is added to BigQuery immediately (in real-time) after the order is approved. It also reduces the labor of manually adding business data to a table.(There is a charge for using Google BigQuery.)* Available in Advanced, Professional

Other Improvements
Enhanced manipulating of Google Sheets
You will be able to use items to update/acquire row data and add/copy sheets in Google Spreadsheets. By using these together with the features that have already been provided such as adding row data, it will be possible to build a mechanism to automate aggregation, report creation, etc. utilizing spreadsheets. * Available in Advanced, Professional
Box: Create/Delete Shared Link of File
You will be able to share the files stored in Box using these items. You can set a password and expiration date for viewing, so you will be able to build a mechanism that allows you to safely share file deliverables such as those created by materials requests and quotation requests with outside parties (requesters, etc.). Previously, it was possible to share in folders, but now it is no longer necessary to create folders just for sharing. * Available in Advanced, Professional
Improved flexibility in Flow Splitting conditions
When Splitting in a workflow, in addition to selecting a conventional conditional expression, you will be able to define an arbitrary conditional expression (SpEL). You will be able to set conditions such as for example, “if the Title starts with [Urgent],” “if it is 24 hours before the deadline,” or “if the annual amount (that is calculated from the monthly amount) is equal to or more than 1 million.” * Available in Basic, Advanced, Professional
See the release notes for details.
Ver. 13.2 Release Note: https://support.questetra.com/versions/version-1320/