NOTE! This site uses cookies and similar technologies.

If you not change browser settings, you agree to it. Learn more

I understand

ETL for Ordinary People

With our ETL software you can automate your business processes in couple of hours, than you can concentrate on what is important: running the business.

Our prices start only from 100 usd per licence.

Today 95 percent of the businesses are small and medium size companies. Most of ETL and business automation software is designed for large companies, it requires highly skilled staff, difficult to support and far too expensive.

Our ETL software was especially designed for ordinary users.

It takes seconds to install it, works straight out of the box, easy to use and easy to support. The trial is fully functional for 30 day and if necessary the trial period can be extended.

Our support team is always happy to connect remotely and assist

Transformation sample


Download Visual Importer ETL Enterprise

Download Advanced ETL Processor Enterprise

Which ETL tool is right for me?

Small business automation

95 percent of the businesses are small and medium sized enterprises, All of them want to automate routine business processes so they can concentrate on what is important: running the business.

We offer Automation software which is easy to use and it works right now. There is no need to hire highly skill staff to deliver automation solution.

With our ETL software complex processes can be automated with days not weeks.

Current BI trends:

Everyone is taking about BIG DATA, as a result of it everything is geared up towards large corporations with big budgets. Most of the solutions are difficult to implement, use and support plus they require high end hardware and large BI teams. It is very expensive and difficult to implement something simple, like automatically sending price list updates to the customers.

Fork as ETL?

Our prices start only from 100 usd per licence.

Our ETL software was especially designed for ordinary users.

It takes seconds to install it, works straight out of the box, easy to use and easy to support. The trial is fully functional for 30 day and if necessary the trial period can be extended.

Our support team is always happy to connect remotely and assist

Transformation sample


Download Visual Importer ETL Enterprise

Download Advanced ETL Processor Enterprise

Which ETL tool is right for me?

Tired of SSIS

Advanced ETL processor vs SSIS.

Development Efficiency against wasting time

One of our Insurance customers has contacted us recently and asked for immediate assistance. They were trying to implement XML files processing for number of weeks using SSIS.
Our consultant was able to deliver working solution within one day using Advanced ETL Processor.

Here is what he did:

Background

The XML files show up every day.  The client places them on FTP server (which means that the file is locally found on our network via a UNC path. )
Each nested XML tag should be a new “related” table.
Main XML tag is "Contracts", Other relevant tags are Billing,Coverage,Person,Risk and Underwriting Question.
There are a couple of data issues as bad dates from the customer. They should be ignored and inserted into the table as a Null.
The process should be scheduled to check an UNC folder on the network at least 3 times per day.
If 1 or more XML files exist, they need to be loaded into the server.
Once loaded an Email should be sent to me indicating success, failure or nothing to do.  
There are some duplicated data due to the relationships of the data.
For example, each contract has Agency information.  So any contract MAY use a previously inserted Agency In this case Update would be appropriate.
Updating data, if same contract is loaded second time all relevant data must be deleted first

Solution

Read more...

Calculating checksum in datawarehousing

Checksum is a calculated value that is used to determine the integrity of data. Checksum serves as a unique identifier for the data (a file, a text string, or a table row). If the data changes then so does the checksum value. This makes it easy to verify the integrity of the data.

Checksum is very useful in data warehousing especially when working with very wide slow changing dimensions. It takes less processing power to compare one checksum field than to compare all fields within dimension.

dbSL ETL software can calculate check sum for entire file, string or row of data. it supports following algorithms CRC16, CRC24, CRC32, Adler32, CRC64, eDonkey, eMule, MD4, MD5, RIPEMD160, SHA1, SHA224, SHA256, SHA384, SHA512,Whirlpool. It can return the data in HEX or BASE64 format.

Calculating checksum

More Articles...

"DBSL software is important part of core business processes and has enabled us to scale up our capacity."

Tim Matter
CRM Team manager,

Our customers

BP

BBC

HSBC

Orange

CAT

SEPA
emc
NHS
Australian Rugby Union
xerox
Databases we work with