AURA Equipements Touts its SQLiPlug

April 9, 2013 Alex Woodie

One AURA Equipements product you will be hearing about more in the future is SQLiPlug, a piece of software that allows IBM i applications to access external databases in real time.

SQLiPlug is not a new product, and it hasn’t been enhanced lately. But according to AURA Equipements CEO Sylvain Rubele, AURA will be doing a lot of work with SQLiPlug in the future, as the company looks to enable database access to and from the IBM i server.

SQLiPlug runs the on IBM i server and facilitates a direct connection between DB2 for i and third-party databases, such as Oracle 11g, MySQL, Microsoft SQL Server, MS Access, Sybase, and Progress‘ database.

The software facilitates direct access to external database tables and procedures through read, insert, update, delete, and call methods, explains AURA product manager Wassel Guerbaa. “When a query is run on the IBM i database, SQLiPlug identifies the information which is on the remote database, performs the corresponding request on it, and returns the results,” Guerbaa tells IT Jungle via email.

AURA has been active in the database connector market recently. In January, the company launched three new database connectors in Launcher/400 that enables users to grab and reformat data sitting on Oracle, MySQL, and PostgreSQL databases. Launcher/400 was originally developed to enable users to access DB2 for i data and then transform it into other formats, such as Word documents, Excel spreadsheets, and PDFs, or distribute them via email or fax.

“SQLiPlug fits into the strategy of opening IBM i to the main databases of the market, like the new database connectors of Launcher/400,” Guerbaa says.

AURA Rolls Out New Database Connectors in Launcher/400

                     Post this story to del.icio.us
               Post this story to Digg
    Post this story to Slashdot

Tags:

YOUR ORGANIZATION NEEDS TO BE THINKING DIFFERENTLY ABOUT YOUR BACKUP & DISASTER RECOVERY STRATEGY

Heightened Concerns of the Industry

Inefficient manual backup processes
Effectively storing data offsite
Developing and testing a concrete disaster recovery plan
Efficient access to data in disaster scenario for necessary users
Risk of cyber security attack
Declining IT staff and resources

The true cause of the above concerns is the “new normal” that is the COVID-19 pandemic and an organization’s status quo:

80% of IBM i users currently backup to tape and 40% of companies
have no DR plan at all.

DURING THIS UNPRESENTEDED TIME, DON’T WAIT FOR YOUR BUSINESS
TO SUFFER A DISASTER TO TAKE ACTION.

The new way to ensure cost-effective safety

Automated cloud backup
Two remote sites – redundant storage, power, internet pipe, firewalls, etc.
Data encryption at all times – in-flight and at-rest
Fully managed remote hardware DR, including remote VPN access for necessary users
Regularly simulated phishing tests and cyber security training

Potential “landmines” in solutions to avoid

Single point of storage – no redundancy
Misleading data analysis, compression/de-dup ratios, sizing of necessary computer resources for backup and DR
Large scale cloud storage with difficult recovery
Inability to meet RTO/RPO

Don’t get caught like the many organizations we’ve seen with inefficient
exposed backup data and no DR plan!

WHAT VAULT400 HAS TO OFFER

Backup

Native software agent schedules backups to the UCG cloud based on your retention scheme
Client data is backed up to two data centers in US or two data centers in Canada
AES bit 256 encryption in-flight and at-rest – 0nly client has the encryption key
Detailed data analysis to ensure proper sizing

Disaster Recovery as a Service