Overview
InFocus supports the use of External Data Sources when using advanced query applets such as: SQL Query and Analytic Dashboard Designer.
Global Settings provides one, central place for managing external data sources and their connection information.
Generally, connections entered here are configured for connecting to SQL databases. That said, use the Custom CX option for connecting to other third party data source (e.g. Access, Oracle, etc.)
Field Descriptions
| • | Name - Name to appear throughout InFocus in data source drop-downs |
| • | Server Name - SQL server name |
| • | Use Integrated Security - Check to use Windows Authentication |
| • | User Id - SQL Server user id to use in the connection string |
| • | Password - SQL Server password to use in the connection string |
| • | Use Encryption - Check to encrypt communication to/from the SQL Server. Defaults to checked. |
| • | Connect Timeout - Defines the number of seconds InFocus will attempt to connect to the data source before dropping the connection |
| • | Custom CX - Used for writing your own connections to SQL, Access, Oracle, etc. |
|