Access to Invantive packages, procedures and functions using SQL Server Management Studio

Wiki (en)
,
1

Invantive packages, procedures, and functions are now visible directly within SQL Server Management Studio (SSMS)** under the familiar Programmability section.

image
image925×783 63.4 KB

The example above shows the table function HTTPDOWNLOAD and it’s parameters.

This new integration makes it easier for developers new to Invantive UniversalSQL to explore the available business logic—executed across over 80 supported (cloud) platforms—within a familiar SQL Server environment.

Since SQL Server does not natively support packages or modules, Invantive maps packages to schemas, exposing the public procedures and functions as part of that schema structure.

Example

USE [DataDictionary]
GO

SELECT * FROM [Invantive].[HTTPDOWNLOAD] (
   'https://nu.nl'
)
GO

select * from avw.dbo.adm_list

Availability

Access to packages, procedures and functions is expected to be available from release 24.1.88-BETA onward.