Encontrar

Artigo
· Out. 29 2min de leitura

Conectarse al servidor SQL mediante autenticación de Windows

#Administração do Sistema #Dicas e truques #ODBC #SQL #System Alerting and Monitoring (SAM) #Tutorial #InterSystems IRIS #Open Exchange

Tuve el mismo problema que contaba Jerry en el siguiente enlace al conectar IRIS con el servidor SQL. Mi conexión ODBC está configurada para autenticarse mediante autenticación nativa de Windows.

Configurad la conexión ODBC de IRIS con autenticación de Windows utilizando una cuenta de dominio específica en lugar de la cuenta predeterminada del servidor IRIS

¿Cómo lo solucioné yo?

La raíz del problema

  • El DSN del servidor SQL estaba configurado con autenticación integrada de Windows.
  • IRIS abre la conexión ODBC a través de irisdb.exe, que se ejecuta bajo la cuenta de inicio de sesión del servicio de Windows de IRIS.
  • Mis servicios de IRIS se estaban ejecutando como LocalSystem, por lo que SQL veía la cuenta de la máquina<ORGNAME>\<ASSETID>$. SQL no tenía un inicio de sesión para esa identidad → 18456 / 28000 “Error de inicio de sesión para el usuario ‘…$’”.

Cambié ambos servicios de IRIS para que se ejecutaran con una identidad de dominio que el servidor SQL confiara: <WINDOWSACCOUNTUSERNAME> = <Orgname>\<Username>.

Comandos utilizados (CMD con privilegios de administrador):

"C:\InterSystems\IRIS\bin\iris" stop <instance> quietly 
"C:\InterSystems\IRIS\bin\IRISinstall.exe" setserviceusername <instance> "<YOURWINDOWSACCOUNTUSERNAME>" "<password>" "C:\InterSystems\IRIS\bin\iris" start <instance>

 

Esa utilidad actualiza:

  • InterSystems IRIS Controller for <instance>
  • InterSystems IRIS for <instance>
    ……añade la cuenta a los grupos IRISServices y IRIS_Instance_<instance>, y otorga los permisos NTFS necesarios. 

Por favor, decidme si hay una forma mejor de hacerlo.

Discussão (0)1
Entre ou crie uma conta para continuar
Artigo
· Out. 29 6min de leitura
Open Exchange

Ultimate Guide to Automate WooCommerce Shipping Using AI Technology

#Artificial Intelligence (AI) #Integração Contínua #Soluções de Negócio e Arquiteturas #Machine Learning (ML) #Supply Chain Orchestrator

If you run an online store, you know the headache of shipping. Setting up rates, zones, and rules can feel like solving a complex puzzle, especially as your business grows. One wrong move and you could be losing money or frustrating customers. What if there was a way to bypass all that manual heavy lifting and let intelligent technology handle it for you?

Well, the future of retail is here, where AI is stepping in to automate WooCommerce shipping configuration, transforming a common pain point into a smooth operation. This isn't just about saving time; it's about making smarter, more profitable shipping decisions for your business.

What is WooCommerce Shipping Automation?

At its core, WooCommerce shipping automation is about using software to take over the repetitive and rule-based tasks involved in getting products from your warehouse to your customer’s doorstep. Solutions like InterSystems Supply Chain Orchestrator enhance this process by streamlining data flow and coordination across your entire logistics network. Instead of you manually calculating costs, printing labels, or sending updates, the system handles it automatically.

Think of it as having a dedicated shipping assistant working around the clock. Here are some of the key functions that get automated:

  • Real-time Rate Calculation: Automated systems can fetch live shipping rates directly from carriers like FedEx, UPS, or USPS based on the customer's location, dimensions, and item weight.
  • Label Generation and Printing: From a customer hitting "purchase" to a label appearing in your printer, the process becomes instant. This cuts down on human error and processing time.
  • Tracking and Notifications: Once an order ships, customers expect updates. Automation makes sure they receive tracking numbers and status changes without you lifting a finger, keeping them happy and informed.
  • Shipping Rule Application: This is where the magic happens. Based on specific conditions you set (or that AI helps you define), the system automatically applies the correct shipping cost, whether it's a flat rate, free shipping, or a calculated cost based on weight or order total.

Benefits of Using an AI Assistant for WooCommerce

The true power emerges when you add artificial intelligence into the mix.

An AI assistant doesn't just execute rules, but it also helps in defining and optimizing them. If you're working with a skilled WooCommerce development company, they're likely already exploring these kinds of intelligent solutions.

Here are five standout benefits:

Simplified Configuration

Imagine telling a system, "Offer free shipping over $50, otherwise charge a $7.50 flat rate, but only in the US," and having it instantly create the rules. Within an AI-enabled supply chain, this kind of automation becomes even more powerful, AI translates complex business logic into accurate shipping settings without you needing to navigate endless menus.

Error Reduction and Validation

Manual configurations are prone to mistakes that can cost you money or customers. Using software for optimizing supply chains, AI can identify inconsistencies, logical flaws in your shipping setup, and missing information, flagging them before they become expensive problems.

Time and Efficiency Savings

The hours spent on initial setup, tweaking rates, or troubleshooting can be reallocated to growing your business. With data technology solutions for third party logistics, AI drastically cuts down on the administrative burden associated with shipping management.

Cost Optimization

AI assistants can analyze shipping data, compare carrier rates, and even suggest adjustments to pricing strategy to maximize profitability or offer more competitive rates to customers.

Improved Customer Experience

Accurate and transparent shipping costs at checkout are important for reducing cart abandonment. AI makes sure customers see precise charges, encouraging purchases and building trust.

AI Plugins and Platforms for WooCommerce Shipping Automation

While many plugins provide a little help with shipping, and several complete platforms are stepping up to offer end-to-end automation, often with AI features baked in. These platforms move beyond simple setup to manage the whole post-checkout journey.

Outvio

Outvio presents itself as an all-in-one shipping solution, fulfillment, returns, and even customer support. Its appeal lies in consolidating what might usually require multiple plugins into a single, smooth interface. This means fewer integrations to manage and a more cohesive workflow for your online store.

Shippo

This SaaS platform is a powerhouse for multi-carrier integration. It not only gives automated label printing and address validation but also boasts discounted shipping rates with major carriers like FedEx, USPS, and DHL. Shippo is designed to sync your orders effortlessly and automate tracking notifications, keeping both you and your customers updated.

Shiprocket

For companies, particularly those operating in or with India, Shiprocket provides an intelligent eCommerce logistics solution. Its standout feature is an AI-based courier recommendation engine. This engine analyzes many factors like delivery speed, cost, service quality, and past performance to intelligently suggest the optimal carrier for each specific shipment, ensuring cost-effectiveness and efficiency.

How the WooCommerce Shipping Configuration AI Assistant Works

Understanding the "how" behind these AI assistants demystifies the process and showcases their practicality. Knowing workflow can be beneficial when considering backend development services for custom integration. Here's a typical flow:

Step 1: User Input (Natural Language Prompt)

In the first step, instead of navigating complex forms or code, you simply describe your shipping requirements in plain English.

Step 2: AI Processing and Interpretation

The AI assistant takes your natural language input. It uses sophisticated algorithms to understand your intent, cross-referencing it with your existing WooCommerce data like shipping zones, product weights, and categories. It then translates your request into a structured, machine-readable format for shipping rules.

Step 3: Configuration Generation

Almost instantly, the assistant generates a complete set of shipping rules or a revised rate table. This configuration is ready to be applied directly to your WooCommerce store or integrated into your chosen shipping platform. It handles the nuances of price tiers, weight breaks, and geographical restrictions.

Step 4: Review and Implementation

Before anything goes live, you get to review the AI-generated configuration. The assistant often provides an explanation of the new rules it has created. Once satisfied, a single click is usually all it takes to implement these new settings, activating them for your customers.

This process is invaluable for several use cases:

  • Creating new shipping scenarios from scratch: Launching a new product or expanding to a new region becomes much simpler.
  • Updating existing complex rate tables: Quickly adjust prices or modify rules without manual recalculations.
  • Verifying and optimizing current setups: AI can act as a troubleshooter, checking for inefficiencies or errors in your current configuration. This helps with AI shipping automation for WooCommerce by ensuring rules are logically sound.
  • WooCommerce shipping optimization with AI helps ensure you’re always offering the best balance of cost and speed to your customers.

Concluding Lines

The days of struggling with automate WooCommerce shipping configuration are rapidly becoming a thing of the past. With AI assistants and complete automation platforms, store owners can move beyond the technical intricacies and focus on their core business.

By adopting these intelligent tools, you not only reduce errors and save time but also elevate your customer experience, along with boosting your bottom line. It's not just about managing shipments; it's about transforming your shipping strategy into a competitive advantage.

Discussão (0)1
Entre ou crie uma conta para continuar
Artigo
· Out. 28 3min de leitura
Open Exchange

IRIS Home Assistant Add-On (HAOS)

#Conteinerização #InterSystems IRIS

InterSystems IRIS Community Edition HAOS Add-On

Run InterSystems IRIS inside of Home Assistant, as an add-on.  Before you dismiss this article possibly under the guise that this is just a gimmick, Id like you to step back and take a look at how easy it is to launch IRIS based applications using this platform.  If you look at Open Exchange, you will see dozens of dozens of applications worthy of launching while they are basically hung out to dry as gitware, and launchable if you want to get into a laptop battle with containerd or Docker.  With a simple git repo, and a specification, you can now build your app on IRIS, and make it launchable through a marketplace with limited hassle to your end users.  Run it along side Ollama and the LLM/LAM implementations, expose anything in IRIS as a sensor or expose an endpoint for interaction in your IRIS app to interact with anything you've connected to HAOS.  Wanna restart an IRIS production with a flick of a physical switch or Assisted AI? You can do it with this add-on, or your own, right alongside the home automation hackers.

Getting Started

We're Running HAOS, and we have checked the about box and confirmed our installation method to be "Home Assistant OS".

Installation

For Home Assistant OS, follow these steps:

  • Add the repository to the Add On Store.
  • Restart the Supervisor.
  • Search for "InterSystems IRIS Community Add-ons" and install and start it.
  • Launch the System Management Portal.

Add Repository

The repo for the iris-haos add-on is: 

https://github.com/sween/iris-haos

Navigate to the Add On Store and hit the three dots on the right upper corner and select "repositories"

Click add and close the dialog.

Restart the Supervisor

From the haos cli/shell, run:

ha addons reload

Back in the Add Ons store, you should IRIS listed and available.

Select the Add-On, Install and Start it.

You can post configure the port specifications or add new ones to your application, this one is just setup for the SMP.

The log should show an all too familiar output from messages.log from the container.

Next, select hit the "Open Web UI" Button, and we should be in business with IRIS running on HAOS!

This is made possible by the "network_mode": "host" directive in the add on, which will allow the ports to be exposed to the haos host.

Extra Credit

Scrape a metric from IRIS and display it in HAOS.

Add the following to your `configuration.yaml`:

sensor:
  - platform: rest
    name: iris_log_reads_per_sec
    resource: http://127.0.0.1:52773/api/monitor/metrics
    value_template: >
      {% set lines = value.split('\n') %}
      {% for line in lines %}
        {% if line.startswith('iris_log_reads_per_sec ') %}
          {{ line.split()[-1] }}
        {% endif %}
      {% endfor %}

for some reason, I had to restart the core to enable the sensor.

ha core restart

HAOS sensors can be built with simple rest calls, so here we are scraping the iris prometheus metrics api running on the iris add on inside HAOS.

Now that its a sensor, you can add it to dashboard, do automation based on its values, expose it to Ambient AI, automate away!

So the detail is in the github repo, but Im here to tell you it isnt much, take a peak in the repo, clone it or check it out on Open Exchange, but with a pair of files, and a container, you can build your own add ons too.


Here is the config:

{
  "name": "InterSystems IRIS Health Community (HAOS)",
  "version": "0.1.1",
  "slug": "irishealth",
  "description": "Runs InterSystems IRIS Health Community as a Home Assistant add-on",
  "startup": "services",
  "boot": "auto",
  "arch": ["amd64", "aarch64"],
  "ports": { "1972/tcp": 1972, "52773/tcp": 52773 },
  "icon": "https://raw.githubusercontent.com/sween/iris-haos/main/irishealth/icon.png",
  "options": {
    "endpoint": "http://localhost:52773/csp/sys/UtilHome.csp"
  },
  "schema": {
    "endpoint": "str"
  },
  "webui": "http://[HOST]:[PORT:52773]/csp/sys/UtilHome.csp"
}

Here is the Dockerfile:

FROM containers.intersystems.com/intersystems/irishealth-community:2025.1

Cheers!

Discussão (0)2
Entre ou crie uma conta para continuar
Anúncio
· Out. 28

AI Meetup for Developers and Startups

#Eventos #Encontros #InterSystems IRIS

Join our next in-person Developer Meetup in Boston to explore AI for Developers and Startups.

This event is hosted at CIC Venture Cafe.

Talk 1: Building Agentic conversational systems
Speaker: Suprateem Banerjee, Sales Engineer - AI Specialist, InterSystems

Talk 2: Let’s Talk about Agentic Benchmarks: the good, the bag, the ugly
Speaker: Jayesh Gupta, Solutions Developer, InterSystems

>> Register here
     <--break->

⏱ Day and Time: November 19, 5:30 p.m. to 7:30 p.m.
📍CIC Venture Café in Cambridge, MA

Save your seat now!

Food, beverages, and networking opportunities will be provided as always.
Join our Discord channel to connect with developers from the InterSystems developer ecosystem.

Discussão (0)1
Entre ou crie uma conta para continuar
Anúncio
· Out. 28

Conheça Henry Hamon Rodrigues Pereira - Novo Moderador da Comunidade de Desenvolvedores!

#Developer Community Oficial

Olá Comunidade,

Dê as boas-vindas ao @Henry Pereira como nosso novo moderador na equipe da comunidade de desenvolvedores! 🎉

Como membro ativo, Henry tem compartilhado consistentemente insights valiosos, apoiado outros desenvolvedores e impulsionado discussões significativas em toda a Comunidade. Sua profunda experiência e espírito colaborativo o tornam a escolha perfeita para ajudar a orientar e expandir nossa Comunidade de Desenvolvedores.

Vamos cumprimentar Henry com uma salva de palmas e dar uma olhada em sua biografia!

@Henry Pereira é Líder Técnico e Especialista em Soluções Técnicas e Inovação na BPlus Tecnologia (Brasil)

Algumas palavras sobre ele:

  • Comecei minha carreira em TI no final de 1999, trabalhando no bug do milênio (sim, sou tão velho assim!). Pouco tempo depois, estagiei em uma empresa que usava a tecnologia Caché da InterSystems.
  • Passei quase uma década trabalhando com Ruby on Rails e, durante esse tempo, comecei a escrever meus primeiros artigos técnicos.
  • Desde 2016, voltei a trabalhar com produtos da InterSystems e sou um membro ativo da Comunidade de Desenvolvedores.
  • Nasci no início dos anos 80, sobrevivi ao bug do milênio, à profecia do calendário maia, à vitória da Alemanha por 7 a 1 sobre o Brasil — e ainda tenho muita energia para gastar.
  • Sou casado, pai de dois filhos (13 e 10), cristão e participo da equipe de Mosqueteiros nas competições comunitárias. Quando não estou programando no meu tempo livre, gosto de irritar os vizinhos tocando minha guitarra — bem alto.

BOAS-VINDAS!

Obrigada e parabéns, @Henry Pereira 👏

Estamos felizes em ter você em nossa equipe de moderadores!

2 Comments
Discussão (2)1
Entre ou crie uma conta para continuar