Page background

Jiwa For Jiwa users

Sales intelligence for Jiwa

Jiwa already holds every invoice, customer and product you sell. Salesmatrix turns it into a daily view of who is growing, who is slipping and what to offer next, connected straight to your Jiwa SQL Server in about 30 minutes.

Jiwa at a glance

Connects to
Your Jiwa database on Microsoft SQL Server, directly
Drivers
None. No ODBC driver or data source to set up
Access
A read-only SQL login
Set-up
About 30 minutes, with ready-made Jiwa queries
First data
The next morning

Three steps, one morning

Jiwa keeps its data in Microsoft SQL Server, so The Connector talks to it directly, with nothing extra to install on the Jiwa side.

01

Install The Connector

On any Windows PC or server in your office that can reach the Jiwa SQL Server and stays on overnight. Often that is the SQL Server itself.

02

Add a read-only login

Your IT person creates a SQL login that can read the Jiwa database and nothing else. The Jiwa queries are ready-made, already running every night at a Jiwa site.

03

Open your dashboard

The first load runs overnight. Next morning your customers, products and sales are in Salesmatrix, and each night after that only the new sales are added.

Read the step-by-step set-up guide →

Safe by design

Built for the questions your IT person will ask.

Nothing gets in

The Connector sits inside your network and only ever calls out to Salesmatrix. No firewall ports to open, no VPN, no remote access to your server.

Read-only to Jiwa

It reads with a login that cannot change anything in your database. Nothing is installed inside Jiwa and nothing changes for your Jiwa users.

You can see what is sent

The queries are on the Connection page of your dashboard, and Logs show how many records arrived each night. No black box.

Quiet during the day

It runs overnight and sends only what is new. Updates install themselves and roll back on their own if anything goes wrong.

What Salesmatrix reads from Jiwa

  • Customers (debtors), with their Jiwa categories and classification
  • Inventory items, with their categories and classification
  • Invoice lines: date, customer, item, sales rep, quantity, value excluding tax and cost
  • Contacts linked to your customers

What it leaves alone

  • Payroll and employee records
  • Bank accounts and payments
  • Your general ledger
  • Anything not in the queries you can see on your Connection page

What your Jiwa data becomes

The same sales intelligence portal every Salesmatrix customer uses, filled with your own Jiwa history from day one.

Lapsed and slipping customers

Who has stopped buying, who is buying less of what, and what that is worth.

What to offer next

Products similar customers buy that this one does not, ready for the next call.

Budgets by rep

Set a sales budget from last year's Jiwa sales and track every rep against it, month by month.

Reps on the road

Each rep's own dashboard, and any customer's SWOT on their phone before they walk in.

See all six areas of the portal →

Bringing several Jiwa businesses on board?

If you are part of a group, a buying network or a partner's customer base on Jiwa, we can set you up together: the same ready-made Jiwa queries, one walkthrough session, and each business with its own private dashboard.

Talk to us

Questions from Jiwa users

What does our IT person need to do?

Two things: install The Connector on a Windows machine that can reach the Jiwa SQL Server, and create a SQL Server login with read-only access to the Jiwa database (membership of the db_datareader role is enough). Our Jiwa queries are ready to go, so we finish the rest with you on a short call.

Will it slow Jiwa down?

It runs overnight, outside business hours. After the first load it sends only the previous day's new sales, which takes the database a moment.

Do we need to open anything in our firewall?

No. The Connector only makes outgoing connections to Salesmatrix, the same way a web browser does. Nothing connects in to your network.

Where is our data kept?

On servers at AccuWebHosting.com in Sydney, Australia and Denver, US. Each business has its own private dashboard.

Can we stop it later?

Yes, at any time. Disable the read-only login, or uninstall The Connector from Windows like any other program, and nothing more is sent.

See your Jiwa sales in a new light, tomorrow morning.

50 free user-days, counted from your first import. No credit card.

Start free Book a 20-minute demo