8 min read
One of the most important tasks that a company considers when modernizing their data estate is how to connect all of its data sources.
Data sources contain the data that you want to load into your data warehouse and use for analysis. A data source connector connects to the source and enables you to browse the content of the source.
TimeXtender is built to connect to almost all of your data sources fast and easy.
Take for example this success story with Lansing, the capital of Michigan. When the city wanted a data management solution to combine and unify its data sources into one consolidated location, while also having a technology that was future-proof, it chose TimeXtender.
For Lansing, having data stored and spread out across various siloed data sources, caused keeping track of data quite challenging; for instance, gathering crime data for everyday police work from disparate data sources.
Using TimeXtender, the city was able to integrate all of its numerous data sources to create a single, trusted, modern data estate. This capability allowed law enforcement organizations to have faster, more accurate insights into criminal activity data, improved operational efficiencies, and substantially reduced manual data entry.
Or, consider the case of PetrolValves, a leading manufacturer of valves and actuators for the oil and gas industry. After the organization acquired and merged with several new companies, it needed to find a way to present company-wide data to allow for fast and credible, real-time analysis. To do so, the company turned to TimeXtender.
“We had been limited to a single data discovery tool getting data directly from the ERP,” said Davide Soliani, Head of ICT, PetrolValves. “Now we are free to use parallel discovery tools getting certified data from a centralized data platform. This also allows us to progressively include new data sources without exponentially increasing the complexity of the architecture.”
The ODX Server can connect to data sources through five types of data providers:
TimeXtender makes it super easy to maintain connections to hundreds of data sources. Using the “Data Source Wizard” users can choose from 200+ data sources, enter their credentials and immediately begin the synchronization.
Once the connection is established, simply add a task to define what tables to load into data lake and define a schedule for incremental refreshes. From there, you can filter out specific fields, rows, or even override problematic data types.
For even more customizability users can write custom queries to access their source data. TimeXtender uses our integrated connectors to pass custom written T-SQL directly into the REST API of specific SaaS applications, making custom queries easier than ever.
Once all is configured, TimeXtender will continue to refresh this data, loading it incrementally on a regular basis into your newly created Data Lake. This connection is then made available to all TimeXtender users, to once again extract out of the lake directly into the Modern Data Warehouse with a simple drag and drop.
8 min read
Sep 22, 2023 Written by Aaron Powers, Content Marketing Specialist