QCEO permite conectar indicadores a distintas bases de datos, cada una de las cuáles requiere una cadena de conexión. El campo Data Source dentro de la cadena de conexión especifica la fuente de datos a partir de la cual se extraerán los datos. Esta fuente de datos puede especificarse utilizando:
A continuación, se muestra el listado de las cadenas de conexión que se pueden usar.
| Base de datos | Extensión | Cadena de conexión |
|---|---|---|
| Excel 2003 * |
".xls" |
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\MyExcel.xls;Extended Properties="Excel 8.0;HDR=Yes;IMEX=1"; |
| OLEDB 12 |
Provider=Microsoft.ACE.OLEDB.12.0;Data Source=c:\myFolder\myOldExcelFile.xls;Extended Properties="Excel 8.0;HDR=YES"; | |
| Excel 2007-2016 * |
".xlsx" |
Provider=Microsoft.ACE.OLEDB.12.0;Data Source=c:\myFolder\myExcel2007file.xlsx;Extended Properties="Excel 12.0 Xml;HDR=YES"; |
| OLEDB 12 |
Provider=Microsoft.ACE.OLEDB.12.0;Data Source=c:\myFolder\myExcel2007file.xlsx;Extended Properties="Excel 12.0 Xml;HDR=YES;IMEX=1"; | |
| ".xlsb" |
Provider=Microsoft.ACE.OLEDB.12.0;Data Source=c:\myFolder\myBinaryExcel2007file.xlsb;Extended Properties="Excel 12.0;HDR=YES"; | |
| ".xlsm" |
Provider=Microsoft.ACE.OLEDB.12.0;Data Source=c:\myFolder\myExcel2007file.xlsm;Extended Properties="Excel 12.0 Macro;HDR=YES"; | |
| Access 2003 * |
".mdb" |
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\mydatabase.mdb;User Id=admin;Password=; |
| ".mdb"+psw |
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\mydatabase.mdb;Jet OLEDB:Database Password=MyDbPassword; | |
| ".mdb" + usr & psw |
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\mydatabase.mdb;Jet OLEDB:System Database=system.mdw;User ID=myUsername;Password=myPassword; | |
| Access 2007-20016 * | ".accdb" | Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\myFolder\myAccess2007file.accdb;Persist Security Info=False; |
| ".accdb" + psw | Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\myFolder\myAccess2007file.accdb;Jet OLEDB:Database Password=MyDbPassword; | |
| ".accdb" + ntw | Provider=Microsoft.ACE.OLEDB.12.0;Data Source=\\serverName\shareName\folder\myAccess2007file.accdb; | |
| SQL Server 2005 | .Net | Server=myServerName\myInstanceName;Database=myDataBase;User Id=myUsername;Password=myPassword; |
| OLEDB 9 | Provider=SQLNCLI;Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword; | |
| OLEDB 10 | Provider=SQLNCLI10;Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword; | |
| ODBC 9 | Driver={SQL Native Client};Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword; | |
| ODBC 10 | Driver={SQL Server Native Client 10.0};Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword; | |
| SQL Server 2008 | .Net | Server=myServerAddress;Database=myDataBase;User Id=myUsername;Password=myPassword; |
| OLEDB 10 | Provider=SQLNCLI10;Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword; | |
| ODBC 10 | Driver={SQL Server Native Client 10.0};Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword; | |
| SQL Server 2012 | .Net | Server=myServerAddress;Database=myDataBase;User Id=myUsername;Password=myPassword; |
| OLEDB 11 | Provider=SQLNCLI11;Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword; | |
| ODBC 11 | Driver={SQL Server Native Client 11.0};Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword; | |
| MySQL | .Net | Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword; |
| OLEDB | Provider=MySQLProv;Data Source=mydb;User Id=myUsername;Password=myPassword; | |
| ODBC 3.5.1 | Driver={MySQL ODBC 3.51 Driver};Server=localhost;Database=myDataBase;User=myUsername;Password=myPassword;Option=3; | |
| ODBC 5.1 | Driver={MySQL ODBC 5.1 Driver};Server=localhost;Database=myDataBase;User=myUsername;Password=myPassword;Option=3; | |
| AS/400 | .Net | DataSource=myServerAddress;UserID=myUsername;Password=myPassword;DataCompression=True; |
| OLEDB | Provider=IBMDA400;Data Source=MY_SYSTEM_NAME;User Id=myUsername;Password=myPassword; | |
| Postgre SQL | .Net | User ID=root;Password=myPassword;Host=localhost;Port=5432;Database=myDataBase;Pooling=true;Min Pool Size=0;Max Pool Size=100;Connection Lifetime=0; |
| OLEDB | Provider=PostgreSQL OLE DB Provider;Data Source=myServerAddress;location=myDataBase;User ID=myUsername;password=myPassword;timeout=1000; | |
| SharePoint | OLEDB 12 | Provider=Microsoft.ACE.OLEDB.12.0;WSS;IMEX=2;RetrieveIds=Yes;DATABASE=http://mysharepointsite.com/documents/;LIST={5999B8A0-0C2F-4D4D-9C5A-D7B146E49698}; |
| Interbase | OLEDB | provider=sibprovider;location=localhost:;data source=c:\databases\gdbs\mygdb.gdb; user id=SYSDBA;Password=masterkey; |
| Visual Fox Pro | OLEDB | Provider=vfpoledb;Data Source=C:\MyDbFolder\MyDbContainer.dbc;Collating Sequence=machine; |
* En ocasiones es necesario instalar para las últimas versiones de Microsoft Office el paquete Microsoft Access Database Engine 2010 Redistributable descargable desde https://www.microsoft.com/en-us/download/details.aspx?id=13255.