LeadSquared is a complete CRM & marketing automation software to help businesses capture, nurture, manage & track their leads in one place.
Leadsquared data sits in MySQL database. So, all the connection settings are similar to MySQL data source. On clicking the “+sign”, a list of data sources pops up. In this case, Leadsquared is selected. A new leadsquared data source is named and created.
After naming the data source, the configure tab would require the user to fill in the credentials such as Username, Password, Driver version, JDBC URL and select between connecting via SSH Host or not before testing the connection and updating.
Optimising Incremental Ingestion in MySQL
Also users can select Yes or No to Optimize Incremental Ingestion. If optimize is Yes, all the datasets will undergo full ingestion on every Sunday or every night. If optimize is No, data will be ingesting incrementally and it never goes under complete ingestion.
In Add Tables, the user can add tables either by table or query method, in table method the user is required to apply a table name and filter clause could also be applied whenever required.
On selecting Query, the user must provide a table name and apply SQL Query before creating a table.
In the Run and Schedule tab, the concurrency (number of tables that can run in parallel, a maximum of 7) can be set preferentially before running the job. The status of the job will be updated in the tab below once it’s complete. The jobs can also be set to run automatically by enabling autorun. By default, the frequency is set to every night. Frequency can be changed by clicking on More --> Autorun-->Change Frequency.