Customer Guide

Any user may register as a customer on the Deepfo website, which will provide direct access to the database, either via a connection string, an API or Microsoft SQL Server Management Studio (the customer is responsible for acquiring Microsoft SQL Server Management Studio licences in all cases)

When a user registers as a customer, in addition to the username and password to access their Deepfo account, they will be provided with a server name, a username and a password to access the database.

Access via Microsoft SQL Server Management Studio.

Access the Microsoft SQL Server Management Studio with the "SQL Server Authentication" option and enter the server, username and passwords provided by Deepfo.

Access via connection string

The format of the connection string may vary depending on the customer, with the parameters being as follows:

Driver: SQL Server Native Client 11.0 or SQL Server
Server/Data Source: TuServidor
Database/Initial Catalogue: will be data_es if the registered language is Spanish or data_en if it is English. It is optional.
UID/User id: User name
PWD/Password: Password

Access via API

The API works by sending queries in SQL language via the URL www.deepfo/deepfo/apis.php with the format

www.deepfo.com/deepfo/apis.php?u=User name&p= Password&q=TuSQL

If the query is successful, the data will be returned with the following structure: