HomeWiki
HomeWiki
  • Back to home
  • 2. Connectivity
  • Introduction
  • Custom Script
  • Playground
  • Database Explorer
  • Log Stream
  • Direct Communication
  • Softone
    • Getting Started
  • Datapump
    • Getting Started
    • Crons
    • Legacy Windows Support
    • SDK
      • DB
        • _executeQuery
        • _executeStoreProcedure
        • _executeInsertQuery
        • _executeInsertQueriesInTransaction
      • Import
        • _productsImport
        • _categoriesImport
        • _brandsImport
        • _attributesImport
        • _attributeSetsImport
        • _unitsImport
        • _quantityImport
        • _customersImport
        • _contactsImport
        • _callsImport
        • _eventsImport
        • _tasksImport
        • _ordersImport
        • _usersImport
        • _customerSourceTagsImport
        • _productSourceTagsImport
      • Log
        • _logDebug
        • _logInfo
        • _logWarn
        • _logError
      • Web Requests
        • _httpGetJson
        • _httpPostJson
        • _httpPutJson
        • _httpDeleteJson
        • _httpPatchJson
      • Variables
        • _saveVariable
        • _getVariable
        • _deleteVariable
      • Blob
        • _blobConnect
        • _blobExists
        • _blobGet
        • _blobFind
      • Utils
        • _encodeBase64
        • _sleep
        • _getLastSyncDate
        • _updateLastSyncDate
        • _resetLastSyncDate

Database Explorer

Connectivity Database Explorer: Query Testing and Result Management#

The Datapump Database Explorer is a powerful feature that allows you to interact with your database directly within the Connectivity environment. It provides tools to test queries, view results, and manipulate data before integrating them into your JavaScript scripts.
image.png

Key Features:#

1.
Query Testing:
You can write and execute SQL queries directly in the Database Explorer. This allows you to validate and test your queries before using them in your scripts.
You can write multiple queries in the editor, separating them with a semicolon (;). This enables you to run multiple commands in a single execution.
2.
View Results in a Grid:
After executing a query, the results are displayed in a grid format above the query editor.
The grid allows for easy inspection and analysis of the returned data.
3.
Result Management:
Sort Columns: Click on any column header to sort the data in ascending or descending order. This helps in organizing and analyzing the results more effectively.
Resize Columns: You can resize columns to fit the data or adjust them according to your preference for better visibility.
Rearrange Columns: Drag and drop columns to rearrange them in your desired order, providing a customized view of your data.
4.
Export Data:
The Database Explorer allows you to export the query results. This is useful for reporting, data analysis, or sharing data with others.
Export options typically include formats like CSV, Excel, or JSON, making it easy to work with the data in other tools.

Example Usage:#

Running Multiple Queries:
Sorting and Exporting Data:
After running the above queries, you can sort the "ProductName" column in the first query result, rearrange columns to place "Price" next to "ProductName", and then export the sorted data to a CSV file.

Benefits of the Database Explorer:#

Efficient Query Development:
Test and refine your SQL queries directly in Datapump without switching between tools.
Data Insights:
Visualize and manipulate data in real-time, helping you gain insights and ensure that your queries return the expected results.
Streamlined Workflow:
Once you are satisfied with the query results, you can easily integrate them into your scripts, saving time and reducing errors.
By using the Datapump Database Explorer, you can streamline your database interactions, making it easier to develop, test, and deploy database queries as part of your automated workflows.
Modified at 2024-08-26 11:18:57
Previous
Playground
Next
Log Stream
Built with