Download our agent.
We have made it easy and secure for you to work with your data.
On this page, you can download our data agent and read more about how it works.
Installation guide.
Download the MSI file above.
Run the installation file on the server from which we need to retrieve data
(or on a server that can reach it via the network).
Create a Windows or database user with the necessary permissions on the database you want us to connect to.
Permissions:
– datareader
– viewstate
The process.
To read data on your SQL server, the IFACT user must have the following permissions:
Datareader
This role allows our user to fetch data.
Viewstate
This role allows our user to fetch metadata about tables and columns. This is not always created by default.
To create the Viewstate role, you have to:
USE your-database-name-here
CREATE ROLE [db_ViewState]
GRANT VIEW DATABASE STATE TO [db_ViewState]
How to assign permissions:
Navigate to:
Databases -> your-database-name-here -> security -> users
Open the properties for the IFACT user and assign:
db_Datareader and db_ViewState
Once this is done, we need the following information:
– Server name
– Database name
– Instance name (if not set to default)
– Username and password to the user
How it works?
The agent is installed in the same environment as the data source(s) you want to work with.
The agent connects to our cloud backend, which sends instructions back to the agent. The agent receives information about which source system to contact and which login information to use for reading data from the database.
Information is not stored in the agent, and all data is cleared once it has been sent to our central DataWareHouse, which we host in Microsoft’s data center – Azure.
Learn more about the addresses and ports that our agent communicates with here.
Is it secure?
The agent does not store your data, passwords, metadata or any sensitive information that could compromise your security.
You do not need to open ports in your firewall as the connection is always established from inside to outside. All communication between IFACT and the agent is encrypted with 256-bit SSL.
The entire IFACT setup is built on standard Microsoft technology and follows all best practices for secure IT architecture.
MySql script.
1. Select “Users and Privileges”
2. Select the user you want to grant permissions to
3. Select “Schema Privileges”
4. Click “Add Entry…”
5. In the pop-up window, select “Selected Schema:”, then choose the schema/database to grant access to
6. Choose a schema
7. Grant “Select” the permission
8. Click “Apply”
Repeat step 4 and 5 for each schema/database you need to grant access to. At a minimum, grant access to the schema named “information_schema” as this is used to fetch metadata about other databases the user has access to.
– Server (e.g. local host in the example above)
– Database (e.g. sakila in the example above)
– Username (e.g. test user in the example above)
– Password
Script to create a user in MySQL
CREATE USER `USERNAME`@`%` IDENTIFIED WITH ‘mysql_native_password’ BY ‘HERE-GOES-THE-PASSWORD’
GRANT USAGE ON *.* TO `USERNAME`@`%`
GRANT SELECT ON `information\_schema`.* TO `USERNAME`@`%`
GRANT SELECT ON `DATABASE NAME`.* TO `USERNAME`@`%`
