Question Tom Philippi · Jan 31, 2018 DSN does not show up on InterSystems Ensemble SQL Gateway configuration. I am running InterSystems Ensemble 2016.2 on ubuntu and trying to connect to a remote MS SQL server database.Insofar, I have successfully configured my ubuntu machine to connect to the remote MS SQL server database using unix-odbc. That is: #ODBC #Ensemble 0 1 0 532
Question Tom Philippi · Jan 17, 2018 Http response incomplete when attemting to set up ODBC connection on Ensemble. We are trying to make an ODBC connection via our intersystems ensemble (2016.2 running on ubuntu). However, when I am testing the connection I receive a pop-up that: "Http object response incomplete or invalid.0,#R". Note that the iodbctrace.log remains empty (and it is working because on the first try it registered a 459 error that I should activate kerberos, which I did). Any advise where I should look?I have taken the following actions: 1. Expand the cacheodbc.ini in the mgr directory as follows: #ODBC #Ensemble 0 2 0 1,160
Question Tom Philippi · Jan 8, 2018 Processing multiple SQL-rows at the same time using SQL Inbound adapter I have a database which needs to be synced to another system and considering to use the SQL Inbound adapter to 'watch' the database. The other system, however, has a bulk API so I'd prefer to send multiple SQL rows in a single message to that system. The SQL Inbound adapter seems to trigger a single call (to a process or business operation) per SQL-row. #SQL #Ensemble 0 3 0 575
Question Tom Philippi · Dec 13, 2017 Running SQL queries on Dynamic objects Recently viewed a demo on the new Dynamic Objects in InterSystems (we are still running 2016.1); together with the upcoming IRIS data platform I started thinking about possibilities of building dynamic databases. That is, I can imagine some projects were it might be really nice to store dynamic objects and then run sql queries on them without ever defining the fields of the dynamic objects (i.e. not at storage, but only if you run your sql query). #Global Summit 2017 #InterSystems IRIS #SQL #Caché 0 3 0 547
Question Tom Philippi · Nov 28, 2017 How to best share External Login Tokens accross Business Processes When executing a business process I'd like to share the Login Token from an external system retrieved via one of my business operations across multiple process instances. This means I need to persist the token somewhere. What would be the best approach/pattern to implement this? #Beginner #Business Process (BPL) #Ensemble 1 1 0 230
Question Tom Philippi · Nov 27, 2017 Business Process doesn't result in error when the called business rule does. I am calling a business rule from one of my business processes and I noticed that when the business rule reports an error that the business process calling that rule just stops without any errors. Resultingly it fails to trigger the scope - catch-all construction that is surrounding the business rule. I know that it is possible to view the errors in business rules in the business rules log, but I really like to push an error message to Ens.Alert or something similar when my business rules report an error. How do I achieve that? #Business Process (BPL) #Business Rules #Ensemble 0 2 0 262
Question Tom Philippi · Nov 27, 2017 How to set URL for a httpRequest send via SendFormArray()? How do I set an URL when I post a httpRequest via SendFormArray of my Ensemble Business Operation. Here is my code: #JSON #REST API #Ensemble 0 1 0 715
Question Tom Philippi · Nov 23, 2017 Configuring %CSP.REST for SSL connections I have an Ensemble installation and just build my first RestService (using %CSP.Rest that forwards them to my Business Service). This works nice and fine when I use postman to make REST calls over http (port 57772). However when I attempt to make a request using https over port 443 I receive the following error: #REST API #SSL #Ensemble 1 7 0 800
Question Tom Philippi · Nov 21, 2017 How to update a BPL proces using business rule. Initial questions have been answered. Expanded the post with actual code (see below)So, I'd like to update one (and preferably) more context-fields in my ensemble BPL business process based upon the information in the request that initiates said BPL proces. I got a few questions about that: #Business Process (BPL) #Ensemble 0 5 0 506
Question Tom Philippi · Nov 7, 2017 Connecting to a system over SSL explicit mode I have an Ensemble installation with an FTP business operation which I would like to connect to a server over SSL in explicit mode (see also: https://www.rebex.net/kb/tls-ssl-explicit-implicit/default.aspx). I keep running into timeouts while attempting to do this via Ensemble. Does Ensemble actually support SSL in explicit mode??? Because I can't seem to find any setting where to switch it on. #SSL #Ensemble 0 1 0 481