Topics started by Dilini Fernando

1 Topic

Dilini Fernando
Seasoned Practitioner
Dilini FernandoSeasoned Practitioner
posted in Developer and User Community

How to run Cognite DB Extractor

 Hi! I’m Dilini Fernando from Cognite! This is my first post, and I am super excited to share a how to guide on Cognite’s DB extractor. This post is targeted to folks who have not used the DB extractor before and wish to extract data from popular tabular databases like MySQL, Oracle, and PostgreSQL databases and ingest it to CDF.The post contains three major steps. The first two focus on setting up a database and ODBC driver, and the third step focuses on running the Cognite DB extractor. You could skip steps that are not required for you. For example, if you already have a database setup, you could skip the first step. Step 1: Setting up a databaseDownload Micorosoft SQL Server Express Edition 2019Install the server Note: Remember the password.  You need to enter the password when you are login to SQL Server Install SQL Server Management Studio. Connect SQL Server Management with SQL server 2019.    Open SQL Server Management and select the Authentication as SQL Server Authentication.

0
Dilini Fernando
Seasoned Practitioner
2 years ago

Badge winners

Show all badges
Terms & ConditionsCookie Settings