Get trial

English

Encrypted strings

Connectors in AnalyticsCreator allow users to establish data source connections, enabling efficient data management and analysis. Here’s a comprehensive guide to understanding and setting up various connectors. To create or edit a connector, navigate through the toolbar menu:

  • MS SQL Server
  • Oracle
  • CSV
  • Excel
  • DuckDB (Parquet, CSV, S3 )
  • MS Access
  • OLEDB
  • SAP (using Theobald connector)
  • ODBC AnalyticsCreator provides a friendly interface for generating connection string templates. For several connector types, users can access these templates by clicking the “Template” button. Here’s an example template: PROVIDER=SQLNCLI11;Data Source=[SERVER];Initial Catalog=[DATABASE];Integrated Security=SSPI; Make sure to replace the placeholders [SERVER] and [DATABASE] with the actual server and database names. The CSV connector has unique properties enhancing file handling capabilities. Users should pay attention to these additional settings to ensure seamless file integration and processing. When defining row delimiters, users can utilize specific abbreviations for ease. These include:
  • {CR} for Carriage Return
  • {LF} for Line Feed
  • {t} for Tabulator These specifications enable seamless formatting and data structuring within your source files. For automatic data source description retrieval, ensure your connections to these data sources are active and functional. This automation simplifies data management and improves operational efficiency. Store connector definitions and associated data sources in the cloud. Cloud storage provides a durable and accessible platform for managing your data across different repositories, enhancing collaboration and data security. We highly recommend keeping your connection strings encrypted. To encrypt your string, simply click on Options → Encrypted Strings → New. To use your encrypted strings in your sources, enclose the name you’ve created with # on both sides. For example, if your DSN=DuckDB, the connection string will be #DuckDB#

➡ Next Page

Updated