quick start guide
The TimeXtender Basic plan is free forever and supports powerful data integration in SQL Server and Azure SQL and delivery to PowerBI Premium
1
TimeXtender enables future-proof data integration, allowing you to select and changes your data storage platform anytime.
Local SQL Storage
2
Configure your
Data Storage:
OR
Configure Cloud Storage
AWS RDS SQL
The ODX Instance is how you connect TimeXtender to your data storage such as SQL Server or Azure Data Lake.
3
If running ODX Server and TimeXtender Desktop on the same machine, use "LocalHost"
See Client-Server Setup for more info...
- Add an ODX Instance
- Enter your storage connection details
- Enter the the IP address where the ODX Service is installed.
The ODX Server is the engine that enables the data ingestion of over 250+ different data sources.
4
- Download ODX Server
- Launch & Run the Installer
- Run ODX Server Configuration
TimeXtender Desktop is the low-code UI that allows you to configure data ingestion, preparation, and delivery tasks in a single interface.
5
- Download ODX Server
- Launch & Run the Installer
TimeXtender enables you to connect to over 250+ data sources directly from our web based portal. Select your own or connect to the below sample dataset.
6
- Download ODX Server
- Enter Connection Details
- Use optional sample data:
- Choose Data Source > TimeXtender SQL Data Source
- Enter Name and Description
- Enter Server: txtraining.database.windows.net
- Enter Database: AdventureWorks
- Authentication > SQL Server Authentication
- Enter Username: txlogin
- Enter Password: TimeXtenderRocks!
- Check the box for Trust server certificate
Map your Data Source to your ODX Instance
7
- Go to Instances
- Click: ODX
- Scroll to Mapped Data Sources section and click: Add
- Data Source > Adventure Works
Create the Database TimeXtender will use to store your data.
8
- Launch TimeXtender Desktop
- Double-Click ODX Instance
- Right-Click ODX Instance
- Edit Instance
- Create Storage
Ingest Data from your source to ODX Storage
9
- Add Data Source
- Create a Transfer Task
- Execute Transfer Task
