Encontrar

Artículo
· 10 jul, 2024 Lectura de 2 min

VSCode extension for IPM (Intersystems Package Manager)

Overview

After having some discussions at Global Summit and using a lot of package managers in my day to day development (npm,nuget,Chocolatey, etc) in addition to recently using the InterSystems Package Manager for some CICD process I'm building using Intersystems IRIS and IRIS 4 Health, I wanted an easy and integrated way to search/view/install packages related to the Intersystems tech stack.

I recently built a VSCode extension for IPM repositories that I will be open sourcing and publishing to the marketplace but wanted create this post to get some feedback from the community.

Some features in the extension:

  • VSCode setting for defining multiple repositories
  • Activity Bar Icon/Explorer View
  • List of packages in custom view
  • List/Open github repository configured in package
  • Details for package in a custom view
  • Copy ZPM install command for use in IRIS terminal

Setup/Settings:

When you first start the extension, you will need to configure it. You can do this by accessing the settings.json file and adding something like the following.

"ipm.repositories": [
        {
            "name":"Public IPM",
            "url":"https://pm.community.intersystems.com"
        },
        {
            "name":"Internal Packages",
            "url":"https://[insert private repo here]"
        },
        {
            "name":"Test Packages",
            "url":"https://[insert private repo here]"
        }
    ]

Screenshots:

Ideas/Future

After building this and working with the API, I'd like to propose a couple updates that potentially could be added to the manifest/API for packages to make integrations like this a little easier

  • License field: (This will let the users know if the package license is compatable with their usage)
  • Logo: encoded image for the package. Allow the developer of the package to specify an image
  • Readme: Allow the developer of the package to include a readme markdown file in the package. This can then be displayed in the details section of the extension.
  • Author: Include the author of the package (can be displayed the details view)
  • Verified: Allow for an author to be verified. For example Intersystems could be a verified author

Open Source:

I will open sourcing this extension on my github page after running a few more tests.

Comments/Suggestions

Let me know what you think or if you have suggestions let me know. Would you be interested in using this?

5 comentarios
Comentarios (5)5
Inicie sesión o regístrese para continuar
Artículo
· 10 jul, 2024 Lectura de 1 min

Nova aplicação iris-size-django no OpenExchange

Por que usá-la?

Esse app oferece uma interface fácil para analisar armazenamento:

  • Filtro por base de dado (namespace), nome da global, tamanho utilizado ou tamanho alocado;
  • Veja a soma dos tamanhos usado e alocado para os filtros aplicados;
  • Exporte a tabela para JSON, CSV, ou XML.

 

Como usar

Siga as instruções no arquivo README do repositório GitHub e configure as definições para conectar à sua instância.

 

Como adaptar às suas necessidades

Já que foi construído com Python e Django, você pode facilmente adicionar métodos de análises específicas em api/methods.py e usar as views em views.py para exibí-las.

Além disso, se quiser salvar os dados analisados numa instância local, mas analisar uma externa, você pode definir o arquivo settings.py para a local e usar iris.connect("host:porta/NAMESPACE", "usuário", "senha") em api/methods.py para a instância externa.

 

Mais informação

Você pode ler minha série de artigos Um portal para administrar armazenamento feito com Django para um passo a passo completo do processo de desenvolvimento dessa aplicação.

Fique à vontade para entrar em contato!

Comentarios (0)1
Inicie sesión o regístrese para continuar
Pregunta
· 10 jul, 2024

Capturing the SQL command sent to Cache for an external system

Is there a way to capture the SQL command that was sent to Cache ? I need to know how to do this. Any help would be appreciated. It is from an external application using JDBC or OBDC. Thanks

4 comentarios
Comentarios (4)2
Inicie sesión o regístrese para continuar
Resumen
· 10 jul, 2024

InterSystems Community Q&A Monthly Newsletter #38

Top new questions
Can you answer these questions?
#InterSystems IRIS
Keyboard Mapping in iris session when using Windows ssh.exe
By Jeffrey Drumm
Migrating source control projects from Subversion to Github with IRIS
By Kevin Kindschuh
How to "real" training a machine learning model
By Kurro Lopez
Component registration
By ala zaalouni
Global Mirroring
By Meenakshi Muthu
Increase performance of production
By Meenakshi Muthu
Deferred lock
By Meenakshi Muthu
Error: Invalid Community Edition license, may have exceeded core limit. - Shutting down the system : $zu(56,2)= 0
By Moussa SAMB
Polybase and IRIS
By Adam Doherty
Why does the Rule Editor display a sad face?
By Joshua Wigley
Which are the best practises to handle large JSON?
By Pietro Di Leo
%DynamicObject (JSON) Response into Class Structure
By Scott Roth
Cannot initialize the data source object of OLE DB provider "MSDASQL" for linked server "IRIS"
By Saghir Hussain
Error importing globals from Caché to Iris
By Josep Balagué
Global can be shared by all namespace
By Meenakshi Muthu
How to read from a file
By Smythe Smythee
%session & passing credentials between ZenPages that reside on different healthshare servers
By Carl Maklad
How to call another method in a generated method
By Shuheng Liu
How to send WRITE formatted output to a variable
By Lynn Lantz
CREATE TABLE AS SELECT fails when one specific field is present
By Stefan Schick
How to convert an embeddings vector to be saved as %Vector
By Ditmar Tybussek
Problem with handling Nacks/Errors on IRIS
By Ali Chaib
How can i see the request size in kilobytes/megabytes?
By omer
Migration from Intersystems IRIS to Oracle DB
By Meenakshi Muthu
OnInit() Question - Ens.BusinessOperation (HTTP.OutboundAdapter)
By Scott Roth
#InterSystems IRIS for Health
Best Practice Question - Connecting to REST API's outside of the network
By Scott Roth
JWT enabled FHIR Server web app access
By Ashok Kumar
VS Code client-side editing and class/package changes
By Robert Barbiaux
How to pass the cloned-object from one rule to another, and send the modified object to target Process or Operation in Rule Editor?
By William Liu
Has anyone worked with in Fhir R4 Binary deserialization (From Athena)?
By Victor Castanon
Testing XML input to Router Management Portal or via XML document viewer
By Thomas Haig
Handling non-8-bit characters in HTTP headers.
By Otto Medin
Why do I have running jobs with no Process ID?
By Chris Pursey
Interpreting Application Error Log
By Kim Trieu
Create a unique constraint on an existing table
By Michael Wood
SQL DatePart Not Working With ISO 8601 Formatted Date & Time
By Carl (booz Allen) Deitrich
Looking for examples of creating a JSON web service as "business service" and converting the JSON data received to a HL-7 message in a Transformation.
By Will
Recommended way to read ???? ?? ??? files
By Yone Moreno Jimenez
How to remove line feed and carriage return from start and end, but not from the middle of a string
By Yone Moreno Jimenez
How to apply huge amount of Biz Rules on a cloned object by using Rule Editor?
By William Liu
#InterSystems IRIS BI (DeepSee)
#Ensemble
#HealthShare
#TrakCare
#VSCode
#38Monthly Q&A fromInterSystems Developers
Pregunta
· 10 jul, 2024

Cannot initialize the data source object of OLE DB provider "MSDASQL" for linked server "IRIS"

Hi

I get the following error when I am trying to create a linked server connection via MS OLE DB Provider for ODBC Drivers in MS SQL Server Management Studio. The message I get is:

The OLE DB provider "MSDASQL" for linked server "IRIS" reported an error. The provider did not give any information about the error.
Cannot initialize the data source object of OLE DB provider "MSDASQL" for linked server "IRIS". (Framework Microsoft SqlClient Data Provider)

I have setup the InterSystems ODBC setting on the server. Have enabled a number SPN settings but still getting this error

The full error message is :

 

===================================

The linked server has been created but failed a connection test. Do you want to keep the linked server?

===================================

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

------------------------------
Program Location:

   at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(String sqlCommand, ExecutionTypes executionType, Boolean retry)
   at Microsoft.SqlServer.Management.Smo.ExecutionManager.ExecuteNonQuery(String cmd, Boolean retry)
   at Microsoft.SqlServer.Management.Smo.LinkedServer.TestConnection()
   at Microsoft.SqlServer.Management.SqlManagerUI.LinkedServerProperties.DoPreProcessExecution(RunType runType, ExecutionMode& executionResult)

===================================

The OLE DB provider "MSDASQL" for linked server "IRIS" reported an error. The provider did not give any information about the error.
Cannot initialize the data source object of OLE DB provider "MSDASQL" for linked server "IRIS". (Framework Microsoft SqlClient Data Provider)

------------------------------
For help, click: https://docs.microsoft.com/sql/relational-databases/errors-events/mssqls...

------------------------------
Server Name: ........\..........
Error Number: 7399
Severity: 16
State: 1
Procedure: sp_testlinkedserver
Line Number: 1

Any thoughts?

2 comentarios
Comentarios (2)1
Inicie sesión o regístrese para continuar