silikonvoice.blogg.se - Writing sas code to link salesforce dashboard

#Writing sas code to link salesforce dashboard driver#
#Writing sas code to link salesforce dashboard full#

HTTPS/SSL - QuerySurge supports optional HTTPS/SSL deployment.

#Writing sas code to link salesforce dashboard driver#

Kerberos – QuerySurge supports integration with Kerberos’ security mechanisms (dependent on JDBC driver Kerberos support).TLS support - QuerySurge now supports TLSv1.0, TLSv1.1 and TLSv1.2 for HTTP communications between QuerySurge components.LDAPS - QuerySurge now supports LDAPS (Secure LDAP) authentication.LDAP – QuerySurge deploys with Lightweight Directory Access Protocol (LDAP) authentication option.Data Security – Database passwords and source/target credentials are stored and transmitted between QuerySurge components with AES 256 bit encryption.Staging Tables can be indexed to enhance performance on staged data tables.

#Writing sas code to link salesforce dashboard full#

Full Text Search of your QueryPairs, Reusable Snippets and Staging Queries for key phrases in your SQL.

Data Stagingprovides users with the ability to stage external data in QuerySurge to join data across tables in different databases, to join between a flat file and a database table, or to compare incremental rows that have ETL’d in different time periods.

Version Control tracks Query Pair history changes made over time.

Column threshold option validates fields within a user-defined percentage or value.

Data-type checking validates the data-type difference between source & target or turn this feature off to return all values as strings.

Run DesignTime QueryPair executions as you build queries to ensure they produce the required results .Design flexible queries with Reusable Query Snippets - query fragments that you can use to modularize your queries and speed up the process of bulk QueryPair updates.Create custom QueryPairs (using SQL) between any two points (Source, Staging, Data Warehouse, Big Data, Data Mart) in your architecture.Read more here»Īctivity Log Reports: Two reports that track specific changes for auditing purposes, including manipulations to users or connections. Project Export: Export entire projects and store for backup purposes. Project Import: Import project data into another project on the same instance or into a different environment (Dev/QA/Prod). Read more here»Īssign Agents to Projects: Agents can be shared across projects or dedicated to specific projects. In each assignment, a user can have a different project role (administrator, standard user or participant user). Global Admin User: This new user type administers the QuerySurge instance across multiple projects.Īssign Users to Projects: Users can be assigned to one or more projects. This allows for multiple groups to work on the same QuerySurge server without seeing each other’s assets (project-level security). Multiple projects can now be created in a single QuerySurge instance.