查找

文章
· 一月 2, 2022 阅读大约需 3 分钟
Open Exchange

DB Migration using SQLgateway

#最佳实践 #数据导入和导出 #Docker #SQL #InterSystems IRIS

Thanks to @Yuri Marx we have seen a very nice example for DB migration from Postgres to IRIS.
My personal problem is the use of DBeaver as a migration tool.
Especially as one of the strengths of IRIS ( and also Caché) before is the availability of the
SQLgateways that allow access to any external Db as long as for them an access usinig 
JDBC or ODBC is available. So I extended the package to demonstrate this.

It is a classic OEX package with a complete Docker.
The SQLgateway is installed during Docker build and the required jdbcdriver for Linux
is included in this repo In order to make this demo faster, the size of tables to migrate
have been shrunk a bit. 

How to test

All migration actions can be executed directly from SMP.

1.   
Verify the gateway connection in     
SMP> Administration> Configuration >Connectivity >SqlGateway_Configuration        

To test Connection click edit

 

and Test Connection     

 

- verify Connection successful     
- Be patient at this point. Postgres Containers sometimes take quite some time to talk to you.    
- Wait a little bit, reload the page in browser and try the test again.     

2.
Identifying the source tables. In SMP > Change to Namespace USER then step to     
SMP >Explorers >SQL >Wizards > Data Migration      

3.     
Set required import parameters         
 

- Destination Namespace       
- Type = TABLE      
- Gateway = postgres      >>>  now the first connection is established and you select             
- Schema = public               
- Tables to migrate = all         

4.      
Identify target but change schema to be OEX compatible from public to dc_public         

-   don't forget to click change all     
-  we migrate Definitions and Data so both sides are selected       

5.        
Skipping special settings we use defaults we start the task in background           
       

6.     
Now we check the results and see everything was working without Errors           

- You might see errors if tables depend on the content not yet migrated.       
- And wait for completions until the status shows Done     

7.     
We terminate the Migration Wizzard and return to normal table view filtered by dc*           

- All 8 tables are visible and show meaningful columns  

8.             
Selecting a table and clicking on OpenTable shows reasonable contents            
                         
        

9.    
A look into the related generated Class Definitions confirms the result and successful completion.           

GitHub

3 Comments
讨论 (3)2
登录或注册以继续
文章
· 十二月 30, 2021 阅读大约需 1 分钟

Did you know that IRIS Terminal could do this?!?! History and Aliases!

#终端 #InterSystems IRIS

Hi all,

When is a Developer Community post not a Developer Community post? When it's just a few sentences wrapped around a link to InterSystems documentation! And what better way to finish up 2021 than by telling you about something cool that's been available since v2020.3? As the ball drops in Times Square, curl up with this:

Repeating Previous Commands

I think it will bring you joy! Post your favorite aliases below. Happy New Year!

31 Comments
讨论 (31)9
登录或注册以继续
文章
· 十二月 25, 2021 阅读大约需 2 分钟
Open Exchange

AOC2021-rcc

#Docker ##嵌入式 Python #InterSystems IRIS

After >40 years of writing in-countable lines of code in M*/COS/ISOS (and a bunch of archaic languages)
I decided for myself to set a strong signal for the future. We have Embedded Python available
(still pre-release)! I just felt it as a sacrilege to ignore this excellent NEW opportunity and
stay with the old sermon that I had used for decades.
Advent means the time of waiting and preparing for something important to come. 
So to me, it meant Advent of Embedded Python Code that finally showed up in time.
ALL class methods of 25 exercises + utility are exclusively written using Embedded Python.
And I'm proud that it ranked as #3 completed by registered members of the Developer Community.

For later use I have added also

  • all full descriptions of the exercises as Day*.md,
  • a snapshot of the private leaderboard at the time of completion of the exercise,
  • all test data, exercises input data and alternate exercises input data,
  • result summaries for all Test examples, all Exercises, and all alternate Exercises.
  • fully compatible with ZPM and therefore also available without Docker image So you are able to follow in all details.

Prerequisites

Make sure you have git and Docker desktop installed.
ATTENTION: The Community License of the IRIS preview image expires 12/1/2022

Installation

Clone/git pull the repo into any local directory

 git clone https://github.com/isc-at/AoC2021-rcc.git

Open the terminal in this directory and build and run the IRIS container with your project:

 docker-compose up -d --build

iris.script will import everything you place under /src into IRIS.

How to Test it

Open IRIS terminal:

$ docker-compose exec iris iris session iris
USER>do ##class(dc.aoc2021.Day1).Run()
  • Extended Run parameters: do ##class(dc.aoc2021.Day3).Run(part,test) with part = 1,2 ; run only first or second part of example, anything else = both test = 0 ; use alternate input set test = 1..n ; run other tests as provided by example
; to run all exercises use
for day=0:1:25 do $classmethod("dc.aoc2021.Day"_day,"Run")
; to run all alteratete exercises use  test=0
for day=0:1:25 do $classmethod("dc.aoc2021.Day"_day,"Run",,0)
; to run all first test examples use
for day=0:1:25 do $classmethod("dc.aoc2021.Day"_day,"Run",,1)
; to run ALL this with just one line
for day=0:1:25 for test=-1:1:1 do $classmethod("dc.aoc2021.Day"_day,"Run",,test)

Some exercises have more than 1 example:
Day8:2, Day12:3, Day16:15, Day18:10, Day22:3, Day24:none

; to run all test examlpes of day 16
for example=1:1:15 do ##class(dc.aoc2021.Day16).Run(,example)

Files /data/ALL*.txt hold all available results

GitHub

讨论 (0)3
登录或注册以继续
公告
· 十二月 22, 2021

Enhancement Requests, Ideas and Innovations

#工具 #InterSystems IRIS #Open Exchange

Just wanted to give visibility to a place in GitHub where everybody can publish Enhancement Requests, Ideas and Innovations that would be great to have in our InterSystems Technology ecosystem.

If you want to add your enhancement request, or take a look and see if there is already there and vote for it, contribute, etc..., click on this link. That doesn't guarantee that Product Management decides to go on that direction, they have to balance many things to decide our products roadmap, but having the direct input from our Community is invaluable.

Come on! Go for it and make your suggestions!

1 Comment
讨论 (1)2
登录或注册以继续
文章
· 十二月 21, 2021 阅读大约需 1 分钟

監査ログをプログラムで出力（ユーザやイベント指定など）する方法

#安全 #Caché #Ensemble #InterSystems IRIS #InterSystems IRIS for Health

これは、InterSystems FAQサイトの記事です。
 

監査ログをプログラミングで出力するために、監査ログの一覧を取得する%SYS.Audit クラスのListクエリを利用することができます。


サンプルコードは以下のようになります。

 Set statement=##class(%SQL.Statement).%New()  
 Set status=statement.%PrepareClassQuery("%SYS.Audit","List")
 Set rs=statement.%Execute()  
 Set tab = $char(9)
 While rs.%Next() {    
   Write rs.%Get("TimeStamp")_tab_rs.%Get("Event")_tab_rs.%Get("Username"),!      
}
讨论 (0)1
登录或注册以继续